Converting Bill of Materials to Pivot Table

[keelaboosa]

I've got a BOM in the following format:

Item	Description
1	Pants
1.1	Right Pants Pocket
1.1.1	Keys
1.1.2	Change
1.1.3	Phone
1.2	Left Pants Pocket
1.3	Back Pants Pocket
1.3.1	Wallet
1.3.2	Comb
2	Hat
3	Shirt
3.1	Right Shirt Pocket
3.2	Left Shirt Pocket

<tbody>
</tbody>

I want to turn into this format for a pivot table

L1 L2 L3 Pants Pants Right Pants Pocket Pants Right Pants Pocket Keys Pants Right Pants Pocket Change Pants Right Pants Pocket Phone Pants Left Pants Pocket Pants Back Pants Pocket Pants Back Pants Pocket Wallet Pants Back Pants Pocket Comb Hat Shirt Shirt Right Shirt Pocket Shirt Left Shirt Pocket <tbody> </tbody>
I've figure out how to split the Item column from the first table using Power Query, but I'm at a loss how to get the correct Descriptions in the appropriate cells. Any ideas?

<tbody>
</tbody>

 

[keelaboosa]

Bump