question

ToddBocik-1305 avatar image
0 Votes"
ToddBocik-1305 asked ToddBocik-1305 answered

Power Query - Transform Comma Seperated Values in a Cell into Their Own Rows

I am using Excel in Office 365 version 2002.

I have an Excel worksheet where one column has comma separated data and I want each data point in that column to be broken out into its own row while retaining the information in the other columns. This is hard to explain in words, so
I have loaded an example of the data here: https://covhlth.sharefile.com/share/view/s478a97430aa448fa/fo1289b9-77cf-4768-8738-f371148a7d63

In the worksheet, the top table is the example data and the bottom is the results I am looking for after using Power Query.

Thanks,

Todd

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ToddBocik-1305 avatar image
1 Vote"
ToddBocik-1305 answered

I found the answer. Lesson learned, always click on the advanced option under a step. Basically, I knew I needed to the Split Column. But I did not realize there was the option to split the column into rows found in the Advanced option.


36122-image.png



image.png (22.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.