I have a very long list of data in column B that is shown as follows:
Synergy Marketing & Design, Inc.
18321 Forest Road, Suite B
Lynchburg,*VA*24502
Brett Howell
(434) 363-4180
The Design Group
311 Rivermont Avenue
Lynchburg,*VA*24503
Nancy Marion
(434) 847-0939
Blair Marketing
2309 Atherholt Road
Lynchburg,*VA*24501
Kip Smith
(434) 846-2375
ProfitFindersUSA
Bedford,*VA
Gary Onks
(540) 427-6187
Lamar Advertising Company
3831 Old Forest Road Suite 6
Lynchburg,*VA*24501
Mark Snowden
(434) 385-4524
(800) 788-3009
I want to be able to transpose every set of data into rows like this:
Synergy Marketing & Design, Inc. 18321 Forest Road, Suite B Lynchburg,*VA*24502 Brett Howell (434) 363-4180
The Design Group 311 Rivermont Avenue Lynchburg,*VA*24503 Nancy Marion (434) 847-0939
Blair Marketing 2309 Atherholt Road Lynchburg,*VA*24501 Kip Smith (434) 846-2375
ProfitFindersUSA Bedford,*VA Gary Onks (540) 427-6187
Lamar Advertising Company 3831 Old Forest Road Suite 6 Lynchburg,*VA*24501 Mark Snowden (434) 385-4524 (800) 788-3009
The part I can't figure out is to be able to transpose sets of data that vary is size.
It would be great if there was a way to transpose the rows to a specific column if the row content is a Company Name, addreess, phone number.
Bookmarks