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

Question

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

Answer 1

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.