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

Just to further add, I have 50,000 rows of data with information for each
product in different sets of block

"Zia" wrote:

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

In EXCEL 2007:-

- select the cells that you wish to transpose by highlighting them (in your
example cells A 2 to C 16 inclusive if you start the data at cell A 1)

- Ctrl-C to copy the data

- go to the area of the Worksheet where you wish the transposition to be
placed (for example I chose cell A 22)

- Home group / Paste / Transpose

The data will now be transposed into the area that you selected.

If my comments have helped please hit Yes.

Thanks.



"Zia" wrote:

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

Excel 2007 PivotTable
Transposes, subtotals, charts and more.
Generic business model for all.
http://c0444202.cdn.cloudfiles.racks.../01_06_10.xlsm