Create New Columns Based on Row Data

Try this ....

Edit the table in Power Query

Right click on the Type column / Transform / Trim   (to remove the hidden space on row 3!)

Left click on the Type and on the top Transform menu select Pivot Column.

Value Column = Date Shipped

Advanced option = Don't aggregate.

The click ok.

see attached screen prints

Thanks for reaching out for help.

I have helped you, now please help me by giving kudos.

Remeber we are unpaid volunteers.

Click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !