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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
zjaff69
New Member

Multiple values in row or cell

Hi 

 

I have multiple values in one row and am not able to do it. Please see the below data. 

 

Users          Groups

John           Everyone
                   Finance
                   Warehouse
                   Stores

Scott           Everyone
                   Finance
                   Warehouse
                   Stores

 

I want to get the result below.

 

Users        Groups

John          Everyone
John          Finance
John          Warehouse
John          Stores

 

Can you please help me? I was trying to group all users. I have many users in the finance group. It just an example when I group finance, I can get a count 2 user

 

Thanks

 

 

 

1 ACCEPTED SOLUTION
JirkaZ
Solution Specialist
Solution Specialist

Ah ok - then you'll have to use Split column by delimiter (in Power Query) and you have to choose/type #lf (line feed) as a delimiter

 

JirkaZ_0-1675973857106.png

 

View solution in original post

4 REPLIES 4
zjaff69
New Member

Thanks for your reply, User and group is one row, but the second column has multiple group names in the row. i did not get how I can do this.

 

users.PNG

JirkaZ
Solution Specialist
Solution Specialist

Ah ok - then you'll have to use Split column by delimiter (in Power Query) and you have to choose/type #lf (line feed) as a delimiter

 

JirkaZ_0-1675973857106.png

 

Thanks, It worked!!

JirkaZ
Solution Specialist
Solution Specialist

You can use the Fill Down transformation in Power Query. Note that you have to replace the blank values in the Users column with "null". Without that first step the "Fill Down" will not work.

 

JirkaZ_1-1675969746969.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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