I have an excel sheet that have the following structu

customer type Product 1 Product 2 Product 3
C1 Quantity 456 666 656
C1 Net Sales ($) $ 100 $ 234 $ 555
C2 Quantity 543 777 656
C2 Net Sales ($) $ 100 $ 234 $ 555

I need to transpose it to the following structu

customer Product Net Sales Quantity
C1 Product 1 $ 100 456
C1 Product 2 $ 234 666
C1 Product 3 $ 555 656
C2 Product 1 $ 100 543
C2 Product 2 $ 234 777
C2 Product 3 $ 555 656

the data sheet is very huge..

the number of products is 49
the number of customer is 309

please help me and thanks in advance