HI All,
Am trying to Consolidate Multiple line Connote items DIMS.
for example: have column A as Connote number which is listing parcel type Pallet/Carton shipped per Connote number and DIMS associated with each Parel.
output: am after is one row per consignment
have 5000+ records each month with 1000 unique Connote numbers associated.
how can i achieve this using VBA/Formula's
thanks,
Am trying to Consolidate Multiple line Connote items DIMS.
for example: have column A as Connote number which is listing parcel type Pallet/Carton shipped per Connote number and DIMS associated with each Parel.
ConnoteNumber | Parcel Type | Length | Width | Height | Weight |
1234 | Pallet | 160 | 110 | 145 | 740.00 |
1234 | Pallet | 240 | 110 | 134 | 740.00 |
5456 | Pallet | 120 | 120 | 120 | 360.00 |
5456 | Pallet | 120 | 120 | 80 | 360.00 |
5666 | Pallet | 115 | 102 | 112 | 300.00 |
5666 | Pallet | 77 | 117 | 108 | 300.00 |
8888 | Carton | 21 | 120 | 120 | 85.35 |
8888 | Carton | 21 | 120 | 120 | 85.35 |
8888 | Carton | 21 | 120 | 120 | 85.35 |
8888 | Carton | 25 | 42 | 29 | 85.35 |
8888 | Carton | 18 | 66 | 15 | 85.35 |
8888 | Carton | 11 | 95 | 17 | 85.35 |
output: am after is one row per consignment
ConnoteNumber | Parcel Type | Length | Width | Height | Weight | Length2 | Width2 | Height2 | Weight2 | Length3 | Width3 | Height3 | Weight3 | Length4 | Width4 | Height4 | Weight4 | Length4 | Width4 | Height4 | Weight4 |
1234 | Pallet | 160 | 110 | 145 | 740.00 | 240 | 110 | 134 | 740.00 | ||||||||||||
5456 | Pallet | 120 | 120 | 120 | 360.00 | 120 | 120 | 80 | 360.00 | ||||||||||||
5666 | Pallet | 115 | 102 | 112 | 300.00 | 77 | 117 | 108 | 300.00 | ||||||||||||
8888 | Carton | 21 | 120 | 120 | 85.35 | 21 | 120 | 120 | 85.35 | 21 | 120 | 120 | 85.35 | 25 | 42 | 29 | 85.35 | 11 | 95 | 17 | 85.35 |
have 5000+ records each month with 1000 unique Connote numbers associated.
how can i achieve this using VBA/Formula's
thanks,