Combine 2 tabs in excel

[ZahinOsman]

Hi all,

I am trying to combine 2 sheets into 1. Below I have 2 data sets from Sheet 1 and Sheet 2 respectively. Sheet 1 has headers, but Sheet 2 does not. How do I go about in combining these 2 data sets into a single output, when sheet 2 is just a continuation of sheet 1, albeit without the headers;

Sheet 1:

System CD	Trade ID	Book_Nm	Book CD	Sap Company CD	Country CD	Country Nm	Trade Mnth
BARX_FX_TS	T105977412	EMFRFX_SPFX BARX_FX_TS	EMFRFX_SPFX	7740	SG	Singapore	2021-11
BARX_FX_TS	T105977414	EMFRFX_SPFX BARX_FX_TS	EMFRFX_SPFX	7740	SG	Singapore	2021-11
BARX_FX_TS	T105977418	EMFRFX_SPFX BARX_FX_TS	EMFRFX_SPFX	7740	SG	Singapore	2021-11
BARX_FX_TS	T105977421	EMFRFX_SPFX BARX_FX_TS	EMFRFX_SPFX	7740	SG	Singapore	2021-11
BARX_FX_TS	T105977422	EMFRFX_SPFX BARX_FX_TS	EMFRFX_SPFX	7740	SG	Singapore	2021-11
BARX_FX_TS	T105977507	ECOM_SPFX BARX Cash	ECOM_SPFX	7740	SG	Singapore	2021-10
BARX_FX_TS	T105977508	ECOM_SPFX BARX Cash	ECOM_SPFX	7740	SG	Singapore	2021-10
BARX_FX_TS	T105977509	AUD1_SPFX BARX Cash	AUD1_SPFX	7740	SG	Singapore	2021-10

Sheet 2:

BARX_FX_TS	T105977512	ECOM_TKFX BARX Cash	ECOM_TKFX	7740	JP	Japan	2021-10
BARX_FX_TS	T105977513	ECOM_SPFX BARX Cash	ECOM_SPFX	7740	SG	Singapore	2021-10
BARX_FX_TS	T105977515	ECOM_TKFX BARX Cash	ECOM_TKFX	7740	JP	Japan	2021-10
BARX_FX_TS	T105977516	ECOM_SPFX BARX Cash	ECOM_SPFX	7740	SG	Singapore	2021-10
BARX_FX_TS	T105977517	ECOM_SPFX BARX Cash	ECOM_SPFX	7740	SG	Singapore	2021-10

[ZahinOsman]

To clarify, these 2 sheets are found in the same excel. Meaning 2 different tabs

[alexnajm]

Sounds like a Union based on column position - here's a quick example with your data

[Prometheus]

@ZahinOsman A Union configured to Auto Config by Position will work for you.