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.

Attached Files

Current to Desired Data Outcome.xlsx (15.1 KB, 10 views)