If you need your data to be in the original order-but with the blank rows removed-just insert a column to the left or right of your data, fill it with sequential numbers, perform the sort by any column except that added column, and then delete the rows that are blank (with only something in the numbering column). Obviously, when you do a sort in this manner you could end up with your data out of the original, imported order. All the rows that contain nothing in that column end up at either the end or beginning of the data (depending on if you sort in ascending or descending order) and you can easily delete those rows. The easiest way may be to simply sort the imported data by the column of your choice. There are a number of ways you can approach this problem. Tom wonders if there is a way to easily get rid of these empty rows. After the import Tom has to manually delete those extra rows so he can use the rest of the data. ![]() The importing works fine, but the import process adds lots (dozens and sometimes hundreds) of extra rows that have no data in them. ![]() There are numerous times when Tom has a worksheet imported from another program into Excel so he can work with the data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |