Forum Discussion
How to combine duplicate id, concatenate with comma.
how do i write a vba code to convert from raw data on the left to consolidtaed inventory id on the right? i already have a vba to copy raw data to my billing worksheet, but i dont't know how to c...
eienkisu I would recommend to use PowerQuery. Since your example raw data contained no information on quantities and prices, I could not generate the last three columns, though.
Please see attached.