Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Reply
pcowman
Helper I
Helper I

Multiple Rows into Multiple Columns

‎10-16-2018 07:09 AM

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.

Labels:
Message 1 of 5
6,684 Views
1 ACCEPTED SOLUTION
LivioLanzo
Solution Sage
Solution Sage

‎10-16-2018 07:16 AM

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

Message 2 of 5
6,679 Views
4 REPLIES 4
LivioLanzo
Solution Sage
Solution Sage

‎10-16-2018 07:16 AM

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!  

Message 2 of 5
6,680 Views
pcowman
Helper I
Helper I
In response to LivioLanzo

‎10-16-2018 07:38 AM

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.

Message 3 of 5
6,674 Views
0
LivioLanzo
Solution Sage
Solution Sage
In response to pcowman

‎10-16-2018 07:40 AM

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!  

Message 4 of 5
6,672 Views
pcowman
Helper I
Helper I
In response to LivioLanzo

‎10-16-2018 08:07 AM

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

Message 5 of 5
6,666 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

View All