Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shifting of data to fill into blank cells
hi community
how can i shift of move the data from one colum to another column empty cells: example: A B 1 Apple 2 Orange 3 Melon 4 Strawberry the example above shows 2 columns with 4 rows and I want to move B2 & B4 to fill into A2 & A4 instead of using cut and paste and I need to do several times if my data has more rows, is there any quicker way to shift my data to fill up the empty cells in column A ? thanks community for the help -- oldLearner57 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill blank cells with cells above data | Excel Worksheet Functions | |||
FILL IN BLANK CELLS | Excel Discussion (Misc queries) | |||
Fill blank cells | Excel Discussion (Misc queries) | |||
How would I fill blank cells with the data from a previous cell? | Excel Discussion (Misc queries) | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |