Function to move text data to left blank cell

Hi Experts,

Task that I have is to move text data to left side of blank cell, there are 14 columns and runs in multiple of 100K rows.

DL 	RT			YVR		YYC		SLC		LAX		BNE	
		BNE	BKK	BNE									
TG 			BKK				BNE						LAX
TG 	RT	SYD		SYD	RT				MEL				
		SYD											AKL
MH 	OW	DEL		PER									
	RT	MEL	SIN	DEL	CCU	SIN		MEL		BRV			LAX

Final output after using function:

DL 	RT	YVR	YYC	SLC	LAX	BNE		
BNE	BKK	BNE						
TG 	BKK	BNE	LAX					
TG 	RT	SYD	SYD	RT	MEL			
SYD	AKL							
MH 	OW	DEL	PER					
RT	MEL	SIN	DEL	CCU	SIN	MEL	BRV	LAX

Any suggestion is welcomed,I am not VB expert

Thanks in advance
Karnik