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.