I have the following files:
file A
Col1 Col2
A 1
B 2
C 3
D 4
file B
Col1 Col2
A 1
Aa 1
B 2
C 3
D 4
file C
Col1 Col2
A 1
B 1
Bb 2
C 3
D 4
I want my output file to look like this:
opfile
Col1 Col2a Col2b Col2c
A 1 1 1
Aa 1
B 2 2 1
Bb 2
C 3 3 3
D 4 4 4
How to do this?