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

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
L10Advanced Nutrition and Human Metabolism
L11Experiences in Music and Movement: Birth to Age Eight
L12Lead ECG in acute coronary syndromes : text & pocket
L13L14L15L16L17New Grammar Companion for Teachers
L18Guide to Clinical Assessment and Professional Report
L19L20Column AH:
Text Title
AH10Advanced Nutrition and Human Metabolism
AH11Experiences in Music and Movement: Birth to Age Eight
AH12Lead ECG in acute coronary syndromes : text & pocket
AH13New Grammar Companion for Teachers
AH14Guide to Clinical Assessment and Professional Report
AH15AH16Ideally 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

Please can you post a small sample file showing input/output required.

Hi Guys as requested I've uploaded a sample sheet Register T&D Sample 120150917.xlsm