hi everyone here is code which Merge data in multiple columns into one

http://www.mcgimpsey.com/excel/index.html#xlvbamacros

i just want to do opposite of this

i have data in a column and i want to put it in different columns
(sequentially)

data in a column is separated by an empty cell
say i have data from a1 to a5 then empty cell again a7:a13
again empty cell like wise [n] number of data in "a"

so i want to put a1:a5 data in c1:c5
a7:a13 data in d1:d7 etc etc

i hope i wil get spport from this experts community

many thanx in advance
waiting 4 ur reply