Hi Team,
My Input files Data is not coming in a same Row.it is Coming in two Row.
I want to Remove duplicate transaction ID. After adjusting top Row of Column E and F.
Below is my input Data.from Range("A1:F13")
Expected Output is in Range("a18:f24")
Below is my Data and expected Output. Thanks for your help in advance !
Thanks
mg
My Input files Data is not coming in a same Row.it is Coming in two Row.
I want to Remove duplicate transaction ID. After adjusting top Row of Column E and F.
Below is my input Data.from Range("A1:F13")
Expected Output is in Range("a18:f24")
Below is my Data and expected Output. Thanks for your help in advance !
Book8 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Sr NO | Transaction ID | Amount | User ID | Remittance | User Name | ||
2 | 1 | 435325 | xxx | 421mfg17 | abc | |||
3 | 2 | 435325 | 586 | xxx | ||||
4 | 1 | 438751 | xxx | 63715rt | xyz | |||
5 | 2 | 438751 | 701 | xxx | ||||
6 | 1 | 438765 | xxx | 2715or1 | JKL | |||
7 | 2 | 438765 | 587 | xxx | ||||
8 | 1 | 438777 | xxx | 4715or1 | PQR | |||
9 | 2 | 438777 | 98 | xxx | ||||
10 | 1 | 34908 | xxx | 311326-2-Charge | JKL | |||
11 | 2 | 34908 | 687 | xxx | ||||
12 | 1 | 34925 | xxx | 319265-2-3-Refund | XYZ | |||
13 | 2 | 34925 | 738 | xxx | ||||
14 | ||||||||
15 | ||||||||
16 | ||||||||
17 | Expected output | |||||||
18 | Sr NO | Transaction ID | Amount | User ID | Remittance | User Name | ||
19 | 2 | 435325 | 586 | xxx | 421mfg17 | abc | ||
20 | 2 | 438751 | 701 | xxx | 63715rt | xyz | ||
21 | 2 | 438765 | 587 | xxx | 2715or1 | JKL | ||
22 | 2 | 438777 | 98 | xxx | 4715or1 | PQR | ||
23 | 2 | 34908 | 687 | xxx | 311326-2-Charge | JKL | ||
24 | 2 | 34925 | 738 | xxx | 319265-2-3-Refund | XYZ | ||
Sheet1 |
Thanks
mg