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