Hello everyone, I have an excel problem please help me if you can.

I have ‘Apple’ in A1 and ‘Orange’ in B2

Looks like this in excel:

Apple(A1)
Orange(B2)

I need to move B2 ‘Orange’ to column A at the same row which is A2
while not remove ‘Apple’. A2 is empty space. Here is the result I
need:

Apple(A1)
Orange(A2)


I’m facing about 5000 row of this kind of data. Please let me know any
shortcut way to do this. Thank you very much!!


--
smash123
------------------------------------------------------------------------
smash123's Profile: http://www.excelforum.com/member.php...o&userid=29974
View this thread: http://www.excelforum.com/showthread...hreadid=566536