Move rows into columns
You will need VBA code to get this done. If you would like I could whip up a
code for you if your willing to send me a copy of your workbook?
"TR53" wrote:
I have an Excel sheet that has 8000+ rows that include contact information.
I'd like to move them from all of those rows into 6 columns. Currently it
lookzs like:
name
title
company
address
city/state/zip
phone
...
...
...
And I'd like to create a formula to move it to 6 columns that look like this:
name title company address city/state/zip phone
I'm still an Excel novice but would appreciate any suggestions you might
have. Thanks!
|