Transpose Rows to Columns but Keeping Data in Blocks

**james_ross** · 01-31-2013, 04:31 AM

Hi,

As the title says but I have shown an example below. I need to be able to do this for 106 sets of data each set containing 18 rows. Therefore the output will be 18 rows and 106 columns.

Thank you very much for you help.

Please Login or Register  to view this content.

**RHCPgergo** · 01-31-2013, 05:32 AM

Hi,

try running this macro. I assumed that you only have data in column A.

Please Login or Register  to view this content.

**nilem** · 01-31-2013, 05:42 AM

or

Please Login or Register  to view this content.

**james_ross** · 01-31-2013, 09:00 AM

They both work perfectly.

Thank you very much.

Transpose Rows to Columns but Keeping Data in Blocks

LinkBack

Thread Tools

Rate This Thread

Display

Transpose Rows to Columns but Keeping Data in Blocks

Re: Transpose Rows to Columns but Keeping Data in Blocks

Re: Transpose Rows to Columns but Keeping Data in Blocks

Re: Transpose Rows to Columns but Keeping Data in Blocks

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions