cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JeroniJamboni Frequent Visitor
Frequent Visitor

Combine columns from same table

Hi Guys,

 

I have a table with the following information:
ID; A; B; C
1; A; B; C
2; A; B; C
3; A; B; C

I want to turn these into the following table:
1; A
1; B
1; C
2; A
2; B
2; C

After googeling for a couple of hours, i can't seem to find the solution. Is there a easy solution to this?

Thank you in advance!

With kind regards,

 

Jeroni Jamboni

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Combine columns from same table

hI @JeroniJamboni

 

In the Query Editor,, Select the Letter Columns>>>Go to Transform Tab>>> Unpivot

 

7000.png

Try my new Power BI game Cross the River

View solution in original post

Super User
Super User

Re: Combine columns from same table

@JeroniJamboni

 

You will get below. Delete extraneous columns and rename as necessary

 

7001.png

Try my new Power BI game Cross the River

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Combine columns from same table

hI @JeroniJamboni

 

In the Query Editor,, Select the Letter Columns>>>Go to Transform Tab>>> Unpivot

 

7000.png

Try my new Power BI game Cross the River

View solution in original post

Super User
Super User

Re: Combine columns from same table

@JeroniJamboni

 

You will get below. Delete extraneous columns and rename as necessary

 

7001.png

Try my new Power BI game Cross the River

View solution in original post

JeroniJamboni Frequent Visitor
Frequent Visitor

Re: Combine columns from same table

Awesome! Works like a charm! 
Thank you!

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,497)