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

On Jan 9, 5:37*pm, Toufik wrote:
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

--
Toufik
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.