I have data on 2000 rows going across X amount of columns. What i need is to
sort the data so everything appears in Column A one after another so i can
use it for a VLookup.

Is there any way of doing this?