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