| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
shifting of data to fill into blank cells
One way ..
Put in C1: =IF(AND(A1="",B1=""),"",IF(AND(A1="",B1<""),B1,A1 )) Copy down as far required. This returns the required results in col C. If desired, just copy col C and overwrite col A with a paste special as values. Clean up by deleting cols B & C. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "tikchye_oldLearner57" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
shifting of data to fill into blank cells
try in column C
=A1 & B1 copy down as far as you need to Copy column C and paste values over column A Delete columns B and C "tikchye_oldLearner57" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
shifting of data to fill into blank cells
Select Column A and F5SpecialBlanksOK
EditDeleteShift Cells LeftOK Gord Dibben MS Excel MVP On Wed, 11 Apr 2007 07:20:08 -0700, tikchye_oldLearner57 wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
shifting of data to fill into blank cells
thanks Gord Dibben, very helpful and simplie :0
thanks community as well :) -- oldLearner57 "Gord Dibben" wrote: Select Column A and F5SpecialBlanksOK EditDeleteShift Cells LeftOK Gord Dibben MS Excel MVP On Wed, 11 Apr 2007 07:20:08 -0700, tikchye_oldLearner57 wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
shifting of data to fill into blank cells
thanks bj :) very helpful
thanks community -- oldLearner57 "bj" wrote: try in column C =A1 & B1 copy down as far as you need to Copy column C and paste values over column A Delete columns B and C "tikchye_oldLearner57" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
shifting of data to fill into blank cells
thanks Max :) very helpful
thanks community -- oldLearner57 "Max" wrote: One way .. Put in C1: =IF(AND(A1="",B1=""),"",IF(AND(A1="",B1<""),B1,A1 )) Copy down as far required. This returns the required results in col C. If desired, just copy col C and overwrite col A with a paste special as values. Clean up by deleting cols B & C. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "tikchye_oldLearner57" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
