Forum Discussion
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
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
4 Replies
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.
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.
