Have Excel spreadsheet of repeating products in one column, repeating “Uses” in another column. Some products have 1 use some products have 3 uses. Would like to have a single line item per product with uses listed on the same row in individual cells.
I have some familiarity with power query and power pivot.
Any guidance appreciated.
Bookmarks