cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yuvarajg Member
Member

How to combine 2 columns in to a single column

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
slanka Regular Visitor
Regular Visitor

Re: How to combine 2 columns in to a single column

Hi,

 

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

Unpivot.gif

3 REPLIES 3
Aron_Moore Established Member
Established Member

Re: How to combine 2 columns in to a single column

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

yuvarajg Member
Member

Re: How to combine 2 columns in to a single column

i have 3 columns in a single table.

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

Highlighted
slanka Regular Visitor
Regular Visitor

Re: How to combine 2 columns in to a single column

Hi,

 

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

Unpivot.gif

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 19 members 825 guests
Please welcome our newest community members: