Transposing Multiple Rows into 2 Data columns
 

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

Transposing Multiple Rows into 2 Data columns
 

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.