I have a very large dataset that takes up many sheets of several files. I am trying to automatically transpose the data from two of the many columns in the spreadsheet either with a function or using macros. The dataset contains record numbers in column C and estimated use in column L. There are up to 13 rows for each record, with the record number being repeated in each row. I would like to copy the record number (from column C) one time followed by the estimated use (from column L) transposed so the 13 records are next to the record number. I have attached an image of the sample file as well as an image of what I'm hoping the output file would look like.

File1.GIFFile2.GIF

Any help would be greatly appreciated! If further information is needed, please let me know.

Thank you!