Forum Discussion
Solved
How can i resolve this problem?
I prepared a table in excel with "IF" formula using a data, then i copied and pasted the values in the table as values. Then i have so many blank cells in my table and i cannot delete them easily as...
Have you tried the Filter function ?
Example in file with your source data "as is" in first sheet, and with your source data in a table in second sheet.
"=FILTER(Table1[Provinces];Table1[Countries]=G$1)"
Yes, it works. But i was after how i can get rid of blank cells. what was your strategy to get rid of blank cells ?
Detlef_Lewin thank you for your answer. Power Query is a new world for me, i think i need to learn something about it, it looks useful. But i didn't understand how i can do what you did in Power Query for my issue 🙂🙂
