Forum Discussion
parsing the text
Hi, I am interested in how to convert text that is grouped in one cell (with line break "alt+return") into each cell individually. And vice versa. Please see attached picture.
Hi Matej,
This can easily be done by using Get & Transform (Power Query).
But unfortunately, it's not supported on the Mac!
- Hi Haytham,
no problem. I have windows too. Can you show me how to do it?
Thank you.OK, please find the attached file to test the solution.
You can update the row data and then refresh the next table (Right Click >> Refresh) to see how it works.
This table is linked to a query that works behind the scenes and it converts the data to the shape you want!NOTE: If you don't have Excel 2016, you have to download and install the https://www.microsoft.com/en-us/download/details.aspx?id=39379.
Update:
I've updated the query in the workbook, looks like it was buggy!
Hi Haytam,
this works great but only if I have text value. If I have only one number in cell i get an error. Why?
Please see attached picture.
