Multiple values in row or cell

[zjaff69]

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

[zjaff69]

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.

[JirkaZ · Accepted solution]

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

[zjaff69]

Thanks, It worked!!

[JirkaZ]

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.