Filter only columns with data and ignore the others

Maybe try using a Pivot Table?

Hi,
I have Created a Excel sheet for you to show the basic idea,
It's based on macro.

1. In Sheet2, Cell "B2" - Type the City Name
2. Then press Ctrl + Shift + E
(It's for using your macro code)
3. You'll have your data.
4. If you want to check again Delete All Columns from C and to above procedure.

Hope this one will help you.

Please Login or Register  to view this content.

@AhsanQatar

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Originally Posted by Gregb11

I don't have a full solution for you (because I don't have time to work on it right now), but in your example, to get the header row, in cell C13 you can enter:

=FILTER(C1:AA1,C6:AA6<>"") (You'll have to delete all the headers that are there to get rid of the #spill error

and in cell C14, you can enter:
=FILTER(C6:AA6,C6:AA6<>"")

Maybe this is a start?

Greg, I dont think =FILTER() is native to 2016 (I know I dont have it)?