Hello,
I am looking for a solution that does not require a VBA code, if possible.
I have a dataset with 300 rows and 40 columns of data (addressess and GPS points).
What I was looking for was a way to use the sort function to organize it in a stepped fashion.
I have no problems with using helper columns in the original data.
I just can't seem to get my head around how to do this other than manually.
The first couple columns will always have data. The gaps/blanks fall in after those.
Original Data looks something like this:
Looking to organize it like this: I left the row number so you could see where it moved from. ( i realize the actual row numbers will not change)Please Login or Register to view this content.
I hope this makes sense.Please Login or Register to view this content.
Gray
Bookmarks