Help lol
i have data in a sheet and it is variable number of rows always changes.
within each row of data is various columns of data.
i would like it to consolidate the data to a new sheet so that any identical product codes are consolidated so I just have number of products for each code.
<tbody>
</tbody>
i have data in a sheet and it is variable number of rows always changes.
within each row of data is various columns of data.
i would like it to consolidate the data to a new sheet so that any identical product codes are consolidated so I just have number of products for each code.
Product code | qty | Price buying | Selling £ | Total |
A1234 | 3 | 20 | 30 | 90 |
A1234 | 3 | 20 | 30 | 90 |
A1235 | 3 | 20 | 30 | 90 |
results are like | ||||
A1234 | 6 | |||
A1235 | 3 | |||
<tbody>
</tbody>