Hi,
I want to transpose column data in to row. I have seen many posts (using
INDEX or OFFSET functions) but all these solution assume a fixed block of
data to be transposed, My problem is that the data i have not only has
variable blocks to be transposed but also has some duplicate
headings(headings are duplicate but the data in front of each heading has
different value. Below is the example of data
Col A Col B Col C
PRODUCT COST COMPONENT COST$
A Raw Mat 10
A D L 8
A EQ 4
A IDL 2
A This Level Cost 22
A Raw Mat 3
A DL 2
A IDL 1
A Total Cost 28
B Raw Mat 15
B D L 5
B This Level Cost 20
B Raw Mat 5
B DL 2
B Total Cost 27
For each product, I want to transpose Cost Component and Cost$ in the order
listed above while keeping the duplicate Cost Components with the respective
values.
Any Idea??
Thanks in advance
Zia