Forum Discussion
Solved
[RESOLVED] PowerQuery Replace Null's with Filled Value from Rows with the same identifier
[Riny helped me resolve this, thanks all!] Hey all, Been attempting for a few hours to execute something that seems so simple, but is giving me a lot of trouble. Here's a shot of the dataset I'm ...
OwenMemArts Check if the empty cells that are shown in columns C to G contain nulls in PQ. If not, select the corresponding columns in PQ and replace 'nothing' with 'null'. Then select these columns again, right-click and and Fill Up. Filter out blanks from the 2nd column and I believe you have what you need, If not, please clarify how the end result should look like.
OwenMemArts Check if the empty cells that are shown in columns C to G contain nulls in PQ. If not, select the corresponding columns in PQ and replace 'nothing' with 'null'. Then select these columns again, right-click and and Fill Up. Filter out blanks from the 2nd column and I believe you have what you need, If not, please clarify how the end result should look like.
- This worked! Thank you so much, especially for the quick response.
Have a great day Riny!
Owen
