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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
mouri_kimochi
New Member

Convert rows to multiple column

Hi,

 

I need help to convert this table:

 

NameFeb 2023Mar 2023Apr 2023
Alexxxxxxxxxx
Benxxxxxxxxx
Chrisxxxxxxxxx

 

into this:

 

NameMonthSales
Alex

Feb 2023

xxx
BenFeb 2023xxx
ChrisFeb 2023xxx
AlexMar 2023xxx
BenMar 2023xxx
ChrisMar 2023xxx
AlexApr 2023xxx
BenApr 2023xxx
ChrisApr 2023xxx

 

Before this, i use to copy paste manually and it took way too much time when we have way too much rows.

Thanks.

1 ACCEPTED SOLUTION
isha_dhameliya
New Member

for that you have to unpivot the table,

select the "Feb 2023","Mar 2023","Apr 2023" columns and then select the option "unpivot only selected columns".

OR

select the "Name" column and then select the "unpivot other columns".

View solution in original post

4 REPLIES 4
isha_dhameliya
New Member

for that you have to unpivot the table,

select the "Feb 2023","Mar 2023","Apr 2023" columns and then select the option "unpivot only selected columns".

OR

select the "Name" column and then select the "unpivot other columns".

Mayuri_Ghosh
Frequent Visitor

Hi,

To convert this table you need to unpivot(turns column into rows) it from Power Query Editor. Select the columns and right click >Unpivot. 

Thank you.

Mahesh0016
Solution Sage
Solution Sage

@mouri_kimochi 

 

Mahesh0016_3-1683192549729.png

Mahesh0016_4-1683192584086.png

 

 

 

If this post helps, then please consider Accept it as the solution and kudos to help the other members find it more quickly. 

kodokgraphy2
New Member

on transform data, try to use "Unpivot other column", then select only Name

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors