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.
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.
@jimmyhartington
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.
This worked fine for me. But not elegant as you say.