How to copy one column to another but so no blanks are returned

[Taupo58]

Hi Guys

I have been playing with the following formula in trying to link two columns in a transaction spreadsheet as follows:

{=IFERROR(INDEX($L$10:$L$400,SMALL(IF(ISTEXT($L$10:$L$400),ROW($L$10:$L$400),""),ROW(L10))),"")}

Column L records the titles of a text books purchased; starting in cell L10.
For reasons I won’t bore you with not all cells in column L have entries e.g. L10, L11, L12 may be populated but L13 to L16 blank then L17, L18 populated etc.
Column L range is L10 to L1000
Column AH records the titles of textbooks sold; starting in cell AH10
However, unlike column L, column AH needs to record the textbook titles in the same order they appear in column L, BUT without the blanks
Column AH range is AH10 to AH1000
The formula above returns nothing but I’m thinking it should be; I have tried using ISBLANK instead of ISTEXT, and also tried ISNUMBER on a different column containing only numbers, but with the same nothing returned result

What I want the formula to do is:

Column L:

Text Title
L10 Advanced Nutrition and Human Metabolism
L11 Experiences in Music and Movement: Birth to Age Eight
L12 Lead ECG in acute coronary syndromes : text & pocket
L13
L14
L15
L16
L17 New Grammar Companion for Teachers
L18 Guide to Clinical Assessment and Professional Report
L19
L20

Column AH:

Text Title
AH10 Advanced Nutrition and Human Metabolism
AH11 Experiences in Music and Movement: Birth to Age Eight
AH12 Lead ECG in acute coronary syndromes : text & pocket
AH13 New Grammar Companion for Teachers
AH14 Guide to Clinical Assessment and Professional Report
AH15
AH16

Ideally I don't want the formula to return False or other error text in unpopulated cells in column AH

Appreciate any guidance thanks guys

Cheers

[Special-K]

Try

{=IFERROR(INDEX($L$10:$L$400,SMALL(IF($L$10:$L$400<>"",ROW($L$10:$L$400),""),ROW(L10))),"")}

I think you have to have an array type formula in that part.