My data is laid out as below (except dozens more columns and thousands of rows):
A B C D
Tom Black Sunday Dallas
Dan Green Monday Austin
Bob White Friday Houston
I need it to be presented as such in a new sheet:
A B
Tom Black
Tom Sunday
Tom Dallas
Dan Green
Dan Monday
Dan Austin
Bob White
Bob Friday
Bob Houston
Is there any sort of formula to do this or any recommended procedure? I have around 100 columns and 2,000 rows so the manual ways I can think to do this would be extremely time consuming and error prone.
Bookmarks