Data Analytics
Timespan
explore our new search
Power Query Split to Rows
Power BI
Apr 18, 2023 10:30 PM

Power Query Split to Rows

by HubSite 365 about Wyn Hopkins [MVP]

Microsoft MVP | Author | Speaker | Power BI & Excel Developer & Instructor | Power Query & XLOOKUP | Purpose: Making life easier for people & improving the quality of information for decision makers

Data AnalyticsPower BI

Showcasing the Split to Rows functionality with email addresses using #powerquery #Excel #PowerBI

Showcasing the Split to Rows functionality with email addresses using

Power Query Split to Rows is a feature in the Power Query Editor of Microsoft Excel that allows users to split a single row into multiple rows. It is particularly useful for transforming data from wide to long format. This can be done by selecting a column and then choosing the Split to Rows option from the Transform tab of the ribbon. It is possible to split the data by character, such as a comma or a space, or by a fixed number of characters. For example, if a row contains a long string of text, it can be split into multiple rows based on the number of characters in each row. This feature is also useful for breaking apart data that is stored as a single field in a database.

Nov 4, 2020 — The first thing we are going to do in the editor is split our column. On the Home tab of the Ribbon, go to the Split Column menu and choose By ...

May 22, 2020 — Split into rows · Select the Equipment column by clicking on the column header. · Click Home Split Column (drop-down) By Delimiter. · In the ...

More results from community.powerbi.com