Remove columns with only a heading

[jimmyhartington]

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.

[Admin]

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

[jimmyhartington]

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.

[Admin]

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

remove-cols.transform (3.0 KB)

[jimmyhartington]

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