File / text maniplation

[martial_arts_drummer]

ok, her e is the situation.

I have a text file:

column A seperator Column B
1 : A
2 : B

etc.

I want to convert it to rows, where Column A is the first line, and column B is the second line.

Is there an easy way to do this?

thanks

John

[tpl]

sed 's/:/\n/' <filename

[ghostdog74]

OP wants a transposition.

@OP, if you have Python

#!/usr/bin/env python
a=[]
for line in open("file"):
    line=line.strip().split(" : ")
    a.append(line)
for i in zip(*a):
    print ' : '.join(i)

output

# ./test.py
1 : 2
A : B

[saivin]

@tpl, not sure if that sed command does the job. may be I tried on wrong file.

I guess he wants something like:
Name Id
A 1234
B 2343
C 5656

converted to:
Name A B C
Id 1234 2343 5656

I tried with above and it did not work.