Entering an xls spreadsheet that is not "flat"

0 Votes
I'm working on a project that has a membership spreadsheet that is not flat, meaning, for example, a person's name, email address and physical address are all "stacked" in a spreadsheet column for each person's spreadsheet row. Similarly mobile and landline phone numbers are stacked in the same spreadsheet column. The number of members is approximately 150. Does anyone know of a way to automate the process of creating addition columns and moving information from the stacks into those new columns. This is a huge project if the flat spreadsheet has to be done by hand, likewise, to enter them directly into Constant Contact manually.