Howdy,
In the attached spreadsheet I would like to create the same six columns, but without any blank rows under column B - that is eliminate the rows without any value in the "entry price" column and move everything up so every row in column B is populated. It does not matter if the data in the other columns is lost.
Thanks,
Scott
Click any where in you data, then go to Data > Autofilter, then select the drop-down on column B and select non-blanks
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
....that is great. Thanks.
No problem - Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks