| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shift Rows Up After Row Deletion and Continually Repeat
Hello! I would greatly appreciate your expertise on opening up a text file
and deleting rows of data if they do not meet the format of "0.0", "1.0", "2.0", etc. After that delete any empty rows and shift the rows up to form a consecutive numbering sequence in column A. The order of operations should not matter as long as it is efficient, the total number of rows I'm working with is ~7K. Your time and expertise is greatly appreciated. Kind regards, D.Parker |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MULTIPLY CELLS IN ROWS CONTINUALLY | New Users to Excel | |||
| rows identification and deletion | Excel Discussion (Misc queries) | |||
| On deletion of rows | Excel Discussion (Misc queries) | |||
| how to repeat rows at the bottom while using the rows repeat at to | Setting up and Configuration of Excel | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Threaded Mode
