Excel 2021 - filter function to only include columns with data

[BrerRabbit]

I have a table with alot of data and alot of empty columns.

Can I filter where only those columns with data are included? In other words to summarise and condense the table using the filter function?

Name	School	Art Course	Science Course	Maths Course	English Course
Dorothy	New York		1.5		9.3
Tim	Los Angelos		2.7		4.5
Alan	Boulder		6.8		6.4

 

[Fluff]

Duplicate to: Excel 2021 - filter function to only include columns with data

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.