Hello Experts,
I want to remove the blank columns in the middle, I know we have an option to ignore blank cells at the end.
Please let me if there a way to remove blank columns 
Thank you!
Sangeetha
Sakhethram (BOB member since 2012-02-08)
Not that I know of. You have to sort to move your blank rows to the end and then ignore them.
Debbie
Debbie 
(BOB member since 2005-03-01)
I suppose you could:
Add a column that looks at your data column and checks to see if it’s blank “Yes” or “No”.
Then use the Filtered Rows option on a Combo Box or something to filter the non blanks to a second location.
Good luck.
-tkt
theknowtank (BOB member since 2011-04-20)