Forum Discussion
Splitting data in one cell into separate rows
Hi all, I want to automatically split the 3rd column so that each row only has one number in the 3rd column. Is there a way to do this without manually splitting each row? I am currently doing i...
A quick alternative with legacy Excel e.g. Excel 2013 could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table. The query works for up to 60 comma separated numbers in one cell.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table in another worksheet as well.