Hi everyone,

I have a question regarding separating data that is grouped one after the other in rows.

For example, I have Product a single row followed by its Quantities in the row below it:


Product 1130174
Allocated Quantity: 0 G Rejected Quantity: 12 G
Product 1130175
Allocated Quantity: 0 G Rejected Quantity: 1 G
Product 1130124
Allocated Quantity: 0 G Rejected Quantity: 3 G


This goes on for quite a number of rows.

My 1st question is, how do I separate these rows into columns side by side so that I can find out which products are duplicates?
I would like to relate the quantities to the product but in a column format instead of the following row.

Any help would be very much appreciated.

Thank you.