Beginner question : Table (Transpose and Pivot?)

I would first Split by Delimiter using the "/", and then split the table into a bunch of two row tables using Table.Split, with 2 as the parameter. This gives you a list of two row tables.

Then I would Promote headers on the nested Tables, then reorder the columns in the nested tables.

The promote headers and reorder steps are:

Split1 = List.Transform(PriorStepName, each Table.PromoteHeaders(_))

Reorder = List.Transform(Split1, each Table.ReorderColumns(_, {"ID, "Category", "Product", "Daily Goal"}))

Now you can expand the list into a single table. 

--Nate