How to spilt Words or Delimited data into New Rows using Power Query Editor in Excel - by Samsun
This is a very helpful video for people who want to spilt words or delimited data into new rows using Power Query Editor in Excel. See the video description below:
How to split word/delimited data into new rows in excel for whole dataset.
1. Select whole dataset
2. Press Ctrl+T, then you will see a dialog box "Create table?"
3. Click OK
4. Now go to “Data”
5. Then click “From table/Range
6. Then you will see a power query editor opens up
7. Select the column from where you want to spilt word into rows
8. click spilt column (If you want to separate by comma, then select comma, each occurrence of the delimiter, rows for each words)
9. Click OK
10. In order to transfer final data, Click “Close & Load”
11. Then there will be a new Excel file with your transform data.
12. Now to keep save your transform data, select whole data, copy and paste it to a new workbook
13. Then save the excel file for future use.
Donate to support our channel:
https://www.paypal.com/donate/?busine...
Thank you so much.