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)"
Another approach is to run Text to Columns (Delimited, clear all delimiters) on the data. This re-evaluates a column's contents. Go to special can then identify the blanks.
The downside is Text to Columns is 1 column at a time.