I'm in need of a code that would look for duplicate rows; sum info in one column, and concatenate info in different column before deleting duplicated rows.
Only 3 cells are "criteria" for considering row "duplicated"
Spreadsheet has several "categories" separated by Glass Type description (see column A), so code needs to look in between blank rows in columns B:K
Sample spreadsheet with more details is attached, but here's the short version:
If "OD" "Width" and "Height" are ALL identical in multiple rows, keep only one row, but summarize QTY and concatenate "TAG" info:
QTY OD TAG WIDTH HEIGHT
5 1 3/8" 006 26 50
10 1 3/8" 008 26 50
Need to show:
15 1 3/8" 006;008 26 50
These rows with duplicate data can be anywhere on the sheet (potentially up to 1500 rows of data)
IMPORTANT: data is in split in different categories, so in my plain English code should do following:
start at the bottom of the sheet - go up until blank cell in column "B" (i.e B200)- run the code - continue from B200 up, until next blank cell is reached - run the code....and so on.
Any help would be much appreciated.