DELETE EMPTY CELLS AND MOVE DATA BELOW UP

  • Thread starter Thread starter CHARI
  • Start date Start date
C

CHARI

I NEED TO DELETE THE EMPTY CELL IN COLUMN B AND MOVE THE DATA BELOW IT UP ONE
CELL

EXAMPLE

112234 COLUMN A "BLANK" COLUMN B
BLANK ABCNDKJKJ

I WOULD LIKE 112234 IN COLUMN A AND ABCNDKJKJ IN COLUMN B SO THEY ARE IN THE
SAME ROW
 
I NEED TO DELETE THE EMPTY CELL IN COLUMN B AND MOVE THE DATA BELOW IT UPONE
CELL

EXAMPLE

112234 COLUMN A                   "BLANK"  COLUMN B
BLANK                                    ABCNDKJKJ

I WOULD LIKE 112234 IN COLUMN A AND ABCNDKJKJ IN COLUMN B SO THEY ARE IN THE
SAME ROW
Click to expand...

no need to shout. We're not deaf.
Is this in Excel? "Moving data up" means something totally different
in Access. There *is* no order to rows, so moving things up and down
doesn't mean anything.
 
please take your caps lock off

is this yoru data

COLUMN A COLUMN B
112234 BLANK
BLANK ABCNDKJKJ

and what you want is


COLUMN A COLUMN B
112234 ABCNDKJKJ

how did this happen
is this data releated
is this in a query or a table
why are you trying to do this
 
Back
Top