I am desperately seeking a better way of transposing a large amount of data. By the looks of other posts, my objective is possible with a bit of VBA. Sadly, I am VBA illiterate. I sincerely appreciate your help.
My data looks like this (simplified) [ data is separated by columns "|".
A | May 1 | Jun 25 | Aug 9 | Dec 12
B | Apr 1 | Oct 25
C | Jan 6 | July 7 | Nov 11
I want to make it look like this:
A | May 1
A | June 25
A | Aug 9
A | Dec 12
B | Apr 1
B | Oct 25
C | Jan 6
C | Jul 7
C | Nov 11
I have accomplished this in the past, but it involved importing the table into access, then creating a query for each of the "date" columns, then copying and pasting the results into one table. It was a painful experience considering there are over 2,000 lines on the original table (resulting in 25,00 lines in the combined query).
Any insight you have would be very very greatly appreciated.