How to combine 2 columns in to a single column

[Anonymous]

Hi,

i have following table

Employee_Name       Join_Date         Department_Join Date

   Neema                     25-04-2018                  04-05-2018

   Olga                        15-05-2018                   27-08-2018

I Expect as following table

Employee_Name                     Date

  Neema                                   25-04-2018 

  Neema                                   04-05-2018

  Olga                                       15-05-2018

  Olga                                       27-08-2018     

how can i acheive this?

[slanka · Accepted solution]

Hi,

To achieve this, you need to Unpivot the table data. 

[Aron_Moore]

In query editor; load it as two tables, then append the the tables.

[Anonymous]

i have 3 columns in a single table.

how can i append 2 columns into a single column within a table