Excel Source > Hidden Empty Columns In-Between Populated Ones

[ovetteabejuela]

Hi Community,

How to deal with an excel source with hidden empty columns and these empty columns are in-between those that I needed.

Unline Rows there is Remove Blanks Rows available but for Column there is no Remove Blank Columns command.

How to deal with it using M?

[ovetteabejuela · Accepted solution]

Okay, after a little research I found out that:

- There is now way to remove Empty columns programatically? Hard to believe but I might need to do some more research.

- Hidden columns, can be handled accordingly by Power Query - no need to unhide them.

[ovetteabejuela]

---

@ovetteabejuela wrote:

Okay, after a little research I found out that:

- There is now way to remove Empty columns programatically? Hard to believe but I might need to do some more research.

         Correction: Solution Here, maybe there are other approach but I think this will do.

- Hidden columns, can be handled accordingly by Power Query - no need to unhide them.

---