I have an arrangement of data scattered throughout multiple rows and columns, most of which are blank that I need to arrange in one column, to sort and manipulate later. Aside from sorting each column to remove the blank cells and moving it to one column, is there an easy way to do this?
Bookmarks