Transposing certain columns

[shyam]

I have a statement which runs into some 200 rows. I need to transpose only certain columns (3rd, 4th and 5th) and repeat the data in that corresponding row (1st and 2nd columns) twice below. eg. is given below :

Excel Workbook
	C	D	E	F	G
1	Query	*	*	*	*
2	*	*	*	*	*
3	3000806	AAA	101.5	7.0	7.0
4	3000821	BBB	93.0	7.0	7.0
5	3000837	CCC	26.5	6.0	7.0
6	3000900	DDD	50.0	7.0	7.0
7	*	*	*	*	*
8	*	*	*	*	*
9	Answer	*	*	*	*
10	*	*	*	*	*
11	3000806	AAA	101.5	*	*
12	3000806	AAA	7.0	*	*
13	3000806	AAA	7.0	*	*
14	*	*	*	*	*
15	3000821	BBB	93.0	*	*
16	3000821	BBB	7.0	*	*
17	3000821	BBB	7.0	*	*
18	*	*	*	*	*
19	3000837	CCC	26.5	*	*
20	3000837	CCC	6.0	*	*
21	3000837	CCC	7.0	*	*
22	*	*	*	*	*
23	3000900	DDD	50.0	*	*
24	3000900	DDD	7.0	*	*
25	3000900	DDD	7.0	*	*
Sheet1

Is there any method by which I can derive the result and given above. (either through formula or thru VB).

Many thanks for your kind help.

Regards

Shyam

 

[jbeaucaire]

'ROWS TO COLUMNS
Here's a macro for expanding rows of data to multiple rows parsing out the values in the row while duplicating the header row as categories. There's a sample workbook too you could drop your data into and test it out.

Rows to Columns - Part 1a​

Before running the macro, make sure your data is flush with the left and top of the worksheet, no blank rows, ok? When you run the macro, indicate which column to start the split down, column F in your example above, but if you move it all to column A, then that would be column C, yes?

 

[shyam]

Many thanks for your reply. I am trying out different option given in the link.

Thanks again.

Regards

Shyam