Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Spreadsheet Layout Conversion
7 views
Skip to first unread message
Jason
Feb 21, 2008, 2:47:00 PM2/21/08
to
I have received a spreadsheet that has contact data in a typical "business
card" format. An example would be (With row numbers on left):
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?
0 new messages