Collecting specific portion from a file

I have a file which contains data like

a
b
x
col1:data1
formula:data3
this is for 2
a
c

col1:@bkw
formula:dontad ad
asd
as per

a
\

i want the data from col1 and formula to keep the col1 data in left side of excel and col2 data in right side of it

ex

col1 formula
data1 data3
this is for 2
a
c

@bkw dontad ad
asd
as per

            a
            \\

Thanks

Google "awk one liners" and see if anything there helps you.