I have one sheet with several thousand rows containing part measurement data. The parts are grouped by part type. The measurement units vary from group to group, so each column contains different types of measurements.
I would like some help with a script that will organize all similar data to a single column.
I've attached some sample data.
1. If cell in row H = "No.", then for each vertical array between column I:N and down to the next row where H=No., copy the vertical array of values over to the matching column 0:BE
2. If cells in column M or N are emtpy, then copy text over to columns BF and BG.
3. There should be a matching column in 0:BE for all other cases. If not, return error.