Power Query Automatically remove empty columns and rows from a table in Excel using Power Query Gil RavivDecember 9, 201619 In today's tutorial we will solve a very common challenge in Excel. You start with an Excel table and you wish to condense it by removing all the columns...