Hi all, this is my first post. Here's my question:

I have a large sheet that is related according to rows. The columns are unimportant. There is likely an easy solution to this, but all I need to do is filter out all the blanks - basically squeeze the data from right to left. All I can think of is perhaps transposing the entire sheet, then filtering each column for non-blanks, but that would be very time consuming. I'm somewhat familiar with the advanced filter, but I'm not sure how I could use it here.