Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
pcowman
Helper I
Helper I

Multiple Rows into Multiple Columns

I have an SQL query that returns two columns with multiple values and I need to format it into a key value from the first column with multiple columns made from the values in the second column. I've looked and tried various methods (including pivot/unpivot) in Excel, SQL and Power BI. I'm hoping someone here can point me in the right direction for one of those. Here is a sample of the data being returned:

 

work order sample.PNG

 

What needs to happen is this:

 

work order sample-1.PNG

There may be 1 WC or there may be up to 21 (I believe). The current report -done through another product - shows up to 5.

1 ACCEPTED SOLUTION
LivioLanzo
Solution Sage
Solution Sage

Check this out:

 

https://www.mrexcel.com/forum/power-bi/1063813-convert-2nd-column-values-rows-when-column-1-same-nam...

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

View solution in original post

4 REPLIES 4
LivioLanzo
Solution Sage
Solution Sage

Check this out:

 

https://www.mrexcel.com/forum/power-bi/1063813-convert-2nd-column-values-rows-when-column-1-same-nam...

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Wow, that is exactly what I need. Just I don't know how to add M Code to my file. I'm assuming it's in the Power Query.

Once you are in Power Query, you can go to the advanced editor. That is where the code is pasted

 

 

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

I thought so but hadn't tried it yet. Woot it worked! I would buy you the beverage of your choice if I could.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.