Automatically Transposing Rows to Columns on a Mass Level

[JonM08]

I have a large list of data that is all in one column. Anywhere from 2 - 3 cells at a time need to remain grouped together but transposed from the one column they are under to their own respective columns.

So basically I have

A
B
C
A
B
A
B
C

and what I need is

ABC
AB
ABC

I know how to do this on an individual basis by highlighting one group at a time and then pasting it as a special in a new sheet, but since the data is so huge I'm looking for a way to automatically do it for the whole list. Each "A" is in Bold and I was wondering if one possible solution was if there was a way to create a MACRO to have Excel automatically highlight the bold A and then all of the subsequent cells before the next Bold A and have them pasted together. So the cells in Bold would be the marker for excel to know which cells should be highlighted and copied together.

[rylo]

Hi

How about

Please Login or Register  to view this content.

rylo

[JonM08]

Thank you immensely for taking the time to reply. When using that script it just seems to transpose each cell in the column to one row.

so I start with

A
B
C
A
B
C


and then run the code and get

ABCABC

I hope what I'm asking is clear. Thank you again.

[JonM08]

Nevermind, I closed the spreadsheet, opened up a similar one and ran the script again and it worked. Thank you soooooo much, that was brilliant.