good day,
can anyone help me with this?
I want to append data based on headers not with cell address or column number.
Please see the example below.
I want to run this through macro as well. Can anyone give me a script? Please.
thank you!
source file
| doc num | Dependent Name Last | Dependent Name First | doc num | Dependent Name Last | Dependent Name First | doc num | Dependent Name Last | Dependent Name First |
| 1 | ads | 123 | 1 | | | 1 | asd231 | 12315sfasd |
| 2 | | | 2 | asd | asd231 | 2 | | |
| 3 | qwe231 | 121fsd | 3 | aa231a | wd1eqw131 | 3 | ascas1231ds | xcqweqdw2 |
| 4 | | | 4 | | | 4 | 123dqwdas | asca212e1 |
| 5 | qwe12dasd2 | 12312dasd2 | 5 | | | 5 | | |
desired result
| doc num | Dependent Name Last | Dependent Name First |
| 1 | ads | 123 |
| 2 | | |
| 3 | qwe231 | 121fsd |
| 4 | | |
| 5 | qwe12dasd2 | 12312dasd2 |
| 1 | | |
| 2 | asd | asd231 |
| 3 | aa231a | wd1eqw131 |
| 4 | | |
| 5 | | |
| 1 | asd231 | 12315sfasd |
| 2 | | |
| 3 | ascas1231ds | xcqweqdw2 |
| 4 | 123dqwdas | asca212e1 |
| 5 | | |
