How do you Unstack cells in columns in Power BI?
You might want to try Pivot?
At the bottom of the page is a little about how to use it. And here’s the documentation.
Hope this helps.
Thanks. I have created different worksheets in Excel for the different columns that I had to “unstack”. Imported that into PowerBI and then pivoted the individual columns and copied results to Excel. Lengthy, but that worked.