Text-to-Rows with Power Query

While Text-to-Columns is a handy wizard in Excel to split a single column into multiple columns, it is not uncommon to encounter situations in which you need the column to be split into multiple ‘rows’. In this case, you need to use Power Query instead.

Watch the video for a quick demonstration on using split by row with Power Query.

Text to Rows

Comments

No comments yet. Why don’t you start the discussion?

Leave a ReplyCancel reply