I have a list of contact that are all listed in column A that I would like to copy and transpose so the information lists across multiple columns (so I can sort the info).
The list is about 10,000 lines long so I don't want to have to copy and transpose each one individualy.
Also, the information for each contact is not consistent as one contact may take up 8 lines of the column while another contact may take up 12 so I can't run a single "copy-paste special-transpose" Macro to take care of the entire sheet (unless there is a way to do this with a forumla?).
I created and ran a couple of Macros for copying and pasting 8, 10, & 12 lines of information but I still have to run the Macro on each individual contact.
Is their a faster way to transpose a list like this??
Thanks!
The list is about 10,000 lines long so I don't want to have to copy and transpose each one individualy.
Also, the information for each contact is not consistent as one contact may take up 8 lines of the column while another contact may take up 12 so I can't run a single "copy-paste special-transpose" Macro to take care of the entire sheet (unless there is a way to do this with a forumla?).
I created and ran a couple of Macros for copying and pasting 8, 10, & 12 lines of information but I still have to run the Macro on each individual contact.
Is their a faster way to transpose a list like this??
Thanks!