Help on data cleaning with power query

Dear Sir/Maa'm,

Would like to request you all to help me out of this data cleaning with Power Query , so that I can get the data in an tabular format.

to discribe what the data is.

1. PRODUCTS: Name of products SKU's
2. PTS: Price of the product
3. 1St Hedder: Stockist name (Merged with 3 cells)
4. 2nd Hedder OPENING,SECONDARY, TRANSIT,CLOSING of the product
5. 3rd hedder : Quantity anda value of the product

What I require in tabular format is

Stockist Name in first column
Product name in second column
PTS in third column
Secondary QTY in fourth column
Closing QTY in fifth column

these are required forall the stockist

please do help in the process of data cleaning and making it in an tabular format.

advance thanks

regards,
Jayanta Basu