Hi Everyone,
I have an address list 10,000 rows long (all info in column A) and I was hoping someone could help me with a macro that would transpose the data so that I can do a mailmerge.
There is no consistency with the data, it could be in 3, 4, 5 or more rows... the only pattern I see is that the begining data (the name) is bolded and the data ends at the next bolded name.
Currently I have been selecting and copying the bolded name down till the cell above the next bolded name, then I transpose the data... my fingers are killing me.
I would greatly appreciate your help.
Parra
I have an address list 10,000 rows long (all info in column A) and I was hoping someone could help me with a macro that would transpose the data so that I can do a mailmerge.
There is no consistency with the data, it could be in 3, 4, 5 or more rows... the only pattern I see is that the begining data (the name) is bolded and the data ends at the next bolded name.
Currently I have been selecting and copying the bolded name down till the cell above the next bolded name, then I transpose the data... my fingers are killing me.
I would greatly appreciate your help.
Parra