GROUP BY WITH COLUMNS / BLANK DATA

[Spotto]

Hello everyone, I'm using power query to group by column ADDRESS and VALOR but I can't group fields that are blank.

Address keeps repeating and bringing blank fields 😞

Is there a way to get the result below without repeating the ADDRESS?

tks for help me 🙂

[Anonymous · Accepted solution]

Hi @Spotto ,

What about filtering out the blank?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[adudani]

hi @Spotto ,

maybe after grouping filtering out the blank will resolve the issue?

Unsure if we are able to perform grouping by blanks.

However, you could replace the blanks by a value and group by that value as well.

Let me know if this resolves the issue.

Appreciate a thumbs up if this is helpful.