Hi Excel Guru's..need a vba to resolve this.
Below table is my Onedrive source Data Set residing in Sheet1 (Table 1 )
<tbody>
ID
ST
NAME
Asset
Qty
UOM
Asset2
Qty2
UOM2
Asset3
Qty3
UOM3
Asset4
Qty4
UOM4
Asset5
Qty5
UOM5
Req type
Justy
Enclose
1
16-07-19
xyz
top
5
100
rock
8
80
soft
10
110...