How to Combine two columns in another excel

Help
1

hello guys,
i have one excel Combine.xlsx (9.3 KB)
which contains column like “C” and cloumn “D” i want to combine these two and print the output like in sheet2 in another excel.

output is like
1
2
3
4
5
54
5
57
input u can take from Combine.xlsx file

2

Hi @sayli,

I don’t understand your question completely, but as per my understanding, If you want to print column D values under column E in another sheet, first paste the column C values in new sheet and then read the range (assume RowCount) of new sheet. Then copy values from column D, paste values mentioning the range as

                "A" + RowCount.tostring
3

Hi @sayli,
Please check this one: Combine.zip (17.6 KB)
Someone already asks me about this one.
So what I did here was I looped through the rows of sheet1.
Then i will check if the value of a cell is null or empty.
If not, I will add a row in a data table.
Then after, I will append he data table to sheet2.
Hope this helps :slight_smile:
Despi

5 Likes
4

so this is something i just tried
open excel application scope
read range to datatable DT
for each row in DT
assign To: row(“New Column”) Value: row(“D”).ToString + row(“C”).ToString
Write Range DT

D C New Column
1 1
2 2
3 3
4 4
5 5
54 54
5 5
57 57
Main.xaml (7.4 KB)
1 Like
5

Your solution is better than mine … learned something new from you today @Jan_Brian_Despi :smiley:

2 Likes
6

Good to hear that! :slight_smile:

2 Likes
7

thanks

1 Like
8

If I gave you the right answer, please mark my answer as the solution by ticking check to close this topic and help others as well :slight_smile:

2 Likes
9

Thanks VirajN

1 Like
10

Welcome @sayli

11

hey if i want to add one column next to “New Column” like column “flag” and in that want to differentiate like which data coming from which Column “C” or “D” like
flag
C
C
C
D
C
C
D
C

12

if you check @Jan_Brian_Despi workflow it checks for the null value. Maybe you can tweak it to identify the non null value in the row and assign the appropriate column header as the flag

13

ohkz

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.