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>
Cust ID / Week
w01
w02
w03...