Transposing Multiple Rows into 2 Data columns

[Toufik]

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 advanc

 

[Don Guillett]

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

I was going to copy your data and provide a solution but it did not
line up properly. So, if desired, send your file to dguillett1
@gmail.com with this msg.