cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
davidtabacman Regular Visitor
Regular Visitor

Transform values to be table Key

Hi Community!!
I have the following table that shows for each ID a number of serials (every ID has between 1 and 5 serials):

1.png

I need to run a transformation so I get a table with one column that contains all serials (from the 5 serials columns, but all in one column) and for each serial the ID. Each serial will be unique, but the same ID can appear for more than one serials (for cases where currently the ID has more than 1 serial, as the ID 12863 in the example).

Any ideas of how to do this?
Thanks!!!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Transform values to be table Key

Hi @davidtabacman 

 

You can select all your Serial columns and goto Transform Ribbon and Click Unpivot

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

 

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Transform values to be table Key

Hi @davidtabacman 

 

You can select all your Serial columns and goto Transform Ribbon and Click Unpivot

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

 

View solution in original post

Nathaniel_C Super Contributor
Super Contributor

Re: Transform values to be table Key

Hi @davidtabacman ,
Not sure if understand exactly what you are asking, but try this from the bottom picture. Original table, then convert data type to text if not already done, then create custom column using &, then delete all but the first and the last.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniels.PNG

 

s3.PNG

 

s2.PNG

 

s1.PNG

 

davidtabacman Regular Visitor
Regular Visitor

Re: Transform values to be table Key

Perfect! Thanks!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)