Marketing gave us an Excel file that apparently had a PDF file imported into of addresses. It's basically one huge column, and every 4 rows constitutes a complete record, ie. A1 = Name, A2 = Street Address, A3 = City St Zip, and A4 = Phone. A5 starts with the next Name, etc etc.
Is it possible - or should I say is there an easy way - to reformat this column so that every 4 Rows down become 4 rows across, the next 4 rows down will then move up and format into 4 rows across, so that Column A will all be Names, Column B will all be Street, Column C will be City, ST & Zip, and Column D will be Phone Numbers.
If I had access to the original Data I'm sure I could do a far better export, but that apparently isn't possible and this is all I have to work with. I tried recording a Macro but it didn't work, I tried writing a quick formula but I realize I don't have the skill and thus am appealing to the Excel gods and goddesses! :-)
Thanks for any help!!
Bookmarks