How to merge two excel without keyvalue

For example

Excel1.xlsx
name age sex
30
40

Excel2.xlsx
name sex
frank male
ada female

I need this one
NewExcel.xlsx

name age sex
frank 30 male
ada 40 female

thanks a lot

For example

Excel1.xlsx
name age sex
[null] 30 [null]
[null] 40 [null]

Excel2.xlsx
name sex
frank male
ada female

I need this one
NewExcel.xlsx

name age sex
frank 30 male
ada 40 female

thanks a lot

I try to use Mergedatatable

but…

name age sex
[null] 30 [null]
[null] 40 [null]
frank [null] male
ada [null] female

@zhangfan
Welcome to the forum

we can combine these two datatables when doing the merge row by row in a custom modelling e.g. within a for each block or within a LINQ statement

Can you confirm following:

this is input data and we can rely on it?

Is ensured that both datatable do always have the same rows count and Line n and dt1 will always be combined with the Line and same row index of dt2?

Thanks for support

1 Like

thanks

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