Hello, I'm new to excel so bear with me.
I have a list like this:
John Doe
1234 Happy St
Anywhere, NC 11111
123-123-1234
Happy Guy
4321 Sad St
PO Box 12
Nowhere, WI 55555
321-321-4321
They are all in column A (2000 rows). There is a blank row before each new info section. So what I need is this list in columns.
Column A = Name
Column B = Street Address
Column C = Mailing Address
And so on. I've tried a few things, but I just can't get it all the way.
Thanks!
I have a list like this:
John Doe
1234 Happy St
Anywhere, NC 11111
123-123-1234
Happy Guy
4321 Sad St
PO Box 12
Nowhere, WI 55555
321-321-4321
They are all in column A (2000 rows). There is a blank row before each new info section. So what I need is this list in columns.
Column A = Name
Column B = Street Address
Column C = Mailing Address
And so on. I've tried a few things, but I just can't get it all the way.
Thanks!