I exported a table from MS Access 2007 to Excel. In Excel, I would like a way to transpose all multi-line addresses in the address1 column into other columns. A 3-line address will take up 3 columns, a 4-line will take up 4. Is there a way to do this?
I have attached a file that I think will help.
Thank you,
MikeAddresses from Access 2007.zip