Hi everyone,
I am having two excels with the data sets as:
| field1 | field2 |
| a | e |
| b | f |
| c | g |
| d | h |
| i | m |
| j | n |
| k | o |
| l | p |
| q | u |
| r | v |
| s | w |
| t | x |
my final output should be :
| field1 | field2 | field3 | field4 |
| a | e | 1 | 5 |
| b | f | 2 | 6 |
| c | g | 3 | 7 |
| d | h | 4 | 8 |
| i | m | 1 | 5 |
| j | n | 2 | 6 |
| k | o | 3 | 7 |
| l | p | 4 | 8 |
| q | u | 1 | 5 |
| r | v | 2 | 6 |
| s | w | 3 | 7 |
| t | x | 4 | 8 |
Can anyone please help me on this? Thanks in advance!!
