I have received a spreadsheet that has contact data in a typical "business card" format. An example would be (With row numbers on left): 1 Firstname Lastname 2 Job Title 3 Company 4 Address 1 5 Address 2 6 City, State Zip 7 EMPTY SPACE 8 Firstname Lastname ... I am trying to find a way to convert this data to a table format such as: A B C D E F G H I 1 Firstname Lastname Job Title Company Address 1 Address 2 City State Zip 2 Next record Any suggestions on how to make this type of layout conversion?
