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 Raw Data n Result.xlsx
Raw Data & Result.JPG
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 Raw Data n Result.xlsx
Raw Data & Result.JPG
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/
How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.