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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
bcampbell2
Frequent Visitor

Moving Data Single column data to it's own column

Hello,

I have data that comes over in one column, but I need to make it show up in one row. Below is how it comes over and what I need. I used to pretty strong BI, but I've been out of it for a while and gotten a bit rusty on stuff like this; I think I need to do a custom table.

The below is how my raw data comes over.

bcampbell2_1-1650918520018.png

Below is what I need it to come over as or at least what I need a table visual to look like.

bcampbell2_2-1650918555492.png

I tried making my own column that just filters on each rank (I kinda knew that wouldn't work), and below is what I get.

bcampbell2_3-1650918614669.png

Thank you for all your help.

 

 

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @bcampbell2 ,

 

I'd suggest to do some pivoting in Power Query:

tomfox_0-1650919968378.png

 

Open Power Query, mark the Rank column, click on Pivot column (under transform) and adapt the settings accordingly:

tomfox_1-1650920088416.png

 

 

Does this solve the issue? 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

2 REPLIES 2
vojtechsima
Memorable Member
Memorable Member

Hi, @bcampbell2 
Just pivot your table like this:

vojtechsima_2-1650920158884.png

vojtechsima_3-1650920171204.png

 

 

tackytechtom
Super User
Super User

Hi @bcampbell2 ,

 

I'd suggest to do some pivoting in Power Query:

tomfox_0-1650919968378.png

 

Open Power Query, mark the Rank column, click on Pivot column (under transform) and adapt the settings accordingly:

tomfox_1-1650920088416.png

 

 

Does this solve the issue? 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.