Please see the attached file. On Sheet 1, Column A contains trend codes. Columns B potentially all the way through Column X contain codes that are to be mapped to Column A.
The challenge I have is to take Columns B through X, copy and transpose them onto Sheet 2 so that they are all in one column. Then I need to copy Column A and paste it in the second column on Sheet 2 in each cell next to its corresponding code from Sheet 1.
I could do this all manually, but I am hoping I can automate it with code and there are 1118 rows which could take many hours. I am very familiar with vba for Access, but I have never done any coding for Excel.