Splitting Column Values in Power Query (Excel & Power BI)
Go Analytics is a data analysis and visualization consulting firm specializing in Microsoft Power BI. For any Power BI inquiries, please contact us at https://goanalyticsbi.com/contact.
In this video, we show you how to split column values in Power Query. Power Query is a powerful tool that allows you to transform and clean your data in a seamless and efficient manner. One of the most common tasks in data cleaning is splitting column values, and Power Query makes it incredibly easy to do so.
We start by showing you how to split column values using the "Split Column by Delimiter" option. This option allows you to split a column into multiple columns based on a specified delimiter, such as a comma or a space. We walk you through the steps, from selecting the column to splitting it and cleaning up the resulting columns.
Next, we demonstrate how to split column values using the "Split Column by Number of Characters" option. This option allows you to split a column into multiple columns based on a specified number of characters. This is particularly useful when you have fixed-width data that needs to be split into separate columns.
Enjoy!
For more how-to and tips & tricks videos on Power BI make sure to subscribe to our channel.
About Go Analytics Inc.
We are data analysis and visualization consultants specializing in Power BI. We help organizations create and nurture a data culture.
Need help getting started with Power BI? Let's connect!
Visit our website at https://goanalyticsbi.com
Follow us on Twitter at / goanalyticsinc
Connect with us on LinkedIn at / go-analytics-inc
***
Note: Go Analytics Inc. is not affiliated with Microsoft. Thoughts are our own.