Append Column

Help Activities
, , ,
1

Hi all,

I got a question, I have two excels Excel1 and Excel2.
I want to append the data of ColumnA of Excel1 with ColumnC of Excel2
Same way ColumnB of Excel1 with ColumnD of Excel2 and ColumnC of Excel1 with ColumnE of Excel2.

Note :Both the excels has different Column Names.

Can anyone help me on this? Appreciate your help.

1 Like
2

Hi @amitha.aenugula

Can you please share sample input excels and expected output.

Regards

1 Like
3

Hi @amitha.aenugula

Can you try the below

image
image900×1823 90.4 KB

Cheers!!

1 Like
4

Excel 1
|Column 1 | Column 2 | Column 3 | Column 4|

|786 | abc | 12345 | cc|
|456 | cfg | 7865 | cc|
|678 | uyr | 9865 | cc|
|675 | adf | 56787 | cc|

Excel 2|
|Date | CUCC | Name | ACC|
|10-12-2024 | 673 | rty | 86|
|28-02-2024 | 332 | uyt | 85|
|28-02-2024 | 4576 | hgf | 34|
|28-02-2024 | 567 | kjh | 56|

Output
|Date | CUCC | Name | ACC|
|10-12-2024 | 673 | rty | 86|
|28-02-2024 | 332 | uyt | 85|
|28-02-2024 | 4576 | hgf | 34|
|28-02-2024 | 567 | kjh | 56|
|Empty | 786 | abc | Empty|
|Empty | 456 | cfg | Empty |
|Empty | 678 | uyr | Empty|
|Empty | 675 | adf | Empty |

My output must be something like this

1 Like
5

Hi @amitha.aenugula

Can you try the below

Count_DT=Excel2.Sheet("Sheet1").DataTableValue.Rows.Count+1

image
image900×1747 83.4 KB

BlankProcess20.zip (287.1 KB)

Output:

image

Regards,

1 Like
6

Hi @amitha.aenugula

Check the below zip file. This is done with macros.

BlankProcess20.zip (283.7 KB)

Hope it helps!!

1 Like