How do I add 617 columns with 3 rows of data (name, address, and phone numbers) from columns B, C, D . . . WR (617 columns) to the end of column A (resulting in one column with 1852 rows (3x617)?
Simplified Example:
Current
Company A Company B Company C 101 Oak St 102 Oak St 103 Oak St 555-5555 666-6666 777-7777
Needed
Company A 101 Oak St 555-5555 Company B 102 Oak St 666-6666 Company C 103 Oak St 777-7777
Thanks.
Bookmarks