Hi!
Enter this formula as an array using the key combo of CTRL,SHIFT,ENTER in B1
and copy down until you get blanks:
=IF(ROWS($1:1)<=COUNTA(A$1:A$4),INDEX(A$1:A$4,SMAL L(IF(A$1:A$4<"",ROW(A$1:A$4)-ROW(A$1)+1),ROWS($1:1))),"")
Biff
"travelersway"
wrote in message
news:travelersway.240pmo_1141261810.6701@excelforu m-nospam.com...
I'd like to create an array to place values in column A into Column B
and remove blank cell from column A.
Example:data in column "A" has blank cell at A2, I'd like to have
column "B" show the values and elimate the blank cell.
A............B
4............4
blank.......5
5............6
6
Your assistance is appreciated.
Travelersway
--
travelersway
------------------------------------------------------------------------
travelersway's Profile:
http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=518077