How to make two different excel columns into one

[#1]

Dears,

Need your help in Making two different columns into one as attached below scrrenshots.

Thanks

Akhil

[sunny_talwar]

May be this

Table:

LOAD ABC,

    [Actual 2001],

    [Actual 2002],

    [Budget 2003]

FROM

[..\..\Downloads\Data.xlsx]

(ooxml, embedded labels, table is Sheet2);

Concatenate (Table)

LOAD xyz as ABC,

    [Actual 2001],

    [Actual 2002],

    [Budget 2003]

FROM

[..\..\Downloads\Data.xlsx]

(ooxml, embedded labels, table is Sheet3);