Array formula, copy column to another column ignoring blank

[Tocix]

Hello,

I search the forum for something familiar but I cannot find any. Please help me out. Example column H, row 3-10 have data which includes blank. What I want to do is whatever data entered in column I get extracted to column T without the blank. Copy and paste are tedious for hundreds of pages.

Thank you very much in advance.

a	A	D	E	F	G	H	I	J	K	L	S	T	U	V	W
												123
2												145
3							123					abc
4							145					def
5												789
6							abc					900
7							def
8
9							789
10							900

<tbody>
</tbody>

 

[Marcelo Branco]

Try this array formula in T1 copied down
=IFERROR(INDEX(H$3:H$10,SMALL(IF(H$3:H$10<>"",ROW(H$3:H$10)-ROW(H$3)+1),ROWS(T$1:T1))),"")
Ctrl+Shift+Enter

M.