Datafrom DT's

[ppr (Peter Preuss)]

Its a side-by-side merge

Done on exel directly

• write dt2 to Worksheet of dt1 with a range offset of B1

OR

done on datatable base

How to merge the excel table properly

@Vi_ciel have a look on following flow, supporting different rows count e.g. on dt1, dt2 [grafik] With datatable merge details: [grafik] input / output: [grafik] Kindly note: in case of multiple datatables will have the same column name, it has to be handled in advance by making the col names unique find starter help here: SideBySideMerge_AlsoDifferentRCnts.xaml (10.8 KB)

UPD1 - above is just about mentioning a few options out of many options we do have