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

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

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

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

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

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

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