Forum Discussion
Solved
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 Ware...
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
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.