Need report on Column A which are cust ID that list down week no x qty in 2 columns only
Header Row 1 are week no, (Row can be dynamic too)
Value are ETA qty, (if can select qty or "tbc", empty cell are ignored too)
Thank to advised the vba method
Initial
<tbody>
</tbody>
After
<tbody>
</tbody>
Header Row 1 are week no, (Row can be dynamic too)
Value are ETA qty, (if can select qty or "tbc", empty cell are ignored too)
Thank to advised the vba method
Initial
Cust ID / Week | w01 | w02 | w03 |
xx1 | 4 | 2 | |
xx2 | 2 | 5 |
<tbody>
</tbody>
After
Cust ID | ETA |
xx1 | w02x4,w03x2, |
xx2 | w01x2,w02x5, |
<tbody>
</tbody>