Conversion of Set of Rows ro Column in new sheet.

**apowale** · 01-10-2013, 06:45 AM

Hi All,

I am looking to copy set of rows and paste them into new sheet with "transpose" option.

The data consist of set of 17 rows (sat a1:a17) one below the other with blank row in between.

I need to copy paste same into another sheet with:
A1:17 getting transposed to A1:Q1
A19:A35 getting transposed to B1:Q1
and so on..

The sample data sheet is attached with desire result.
Please advise,

Regards,
Amol.

**nathansav** · 01-10-2013, 06:56 AM

A good way to learn would be to do the operation using cut and paste special, recording a macro, then view the code generated.

**OllieB** · 01-10-2013, 07:28 AM

The following code should do the trick without formulas

Please Login or Register  to view this content.

**apowale** · 01-10-2013, 07:29 AM

Hi Nathansav,

The problem is sample data contains only two such sets, whereas my actual data contains 10000's of such sets.
Also, I am unaware of how to put the things in loop.

Regards,
Amol