Remove columns with only a heading

This seems should be simple I think, but I can not find out how.

I would like to remove all colums, which only has a heading, but no data in any rows for the column.

You can filter rows by their content, but not columns. So I suggest you Transpose, then Filter, then Transpose back.

Then after Transpose I have to remove the first column, which has become the header rows.
So these I have to create again after the last transpose.

Here is another way to do it. But it isn’t exactly elegant.


remove-cols.transform (3.0 KB)

This worked fine for me. But not elegant as you say.

1 Like