Macro for Columns to Row Data
I have Excel data in an unusable format for upload to a system. I need to replicate each row of data, but also convert select columns of data into rows.
In the attached file, I have two sample rows of data and a row of headers in the Current Data tab.
Columns A thru V need to be repeated in new rows to align with converting Columns W thru AR into a single column, but broken out by rows to align with the newly repeated rows for Columns A thru V.
In the Desired Data tab, you can see the results I would like as described above.
I'm not an expert in developing Macros, but this is something that would be repeated monthly for several thousand rows of data, initially.
|