Excel VBA Repeating and Merging Data Into Some Columns

[JOEYSCLEE]

Hi there,

I have the file with multiple columns and looks for VBA code for repeating data and merging data into some columns. Enclosed the following image and file for reference 31375

31374

[June7]

This is known as "unpivot" and "normalizing" data structure. A PowerQuery should accomplish this easier than VBA. Review https://exceloffthegrid.com/power-query-unpivot-data/