Hi,
I have data like below:
1 10
2 20
3 30
4 40
5 50
6 60
1 70
2 80
3 90
4 100
5 110
6 120
1 10
2 20
3 30
4 40
5 50
6 60
1 70
2 80
3 90
4 100
5 110
6 120
1 10
2 20
3 30
4 40
5 50
6 60
1 70
2 80
3 90
4 100
5 110
6 120
I want them to separate and bring in the next column based on when the pattern is being repeated in the first column, arranged data has to look something like below:
1 10 1 70 1 10 1 70 1 10 1 70
2 20 2 80 2 20 2 80 2 20 2 80
3 30 3 90 3 30 3 90 3 30 3 90
4 40 4 100 4 40 4 100 4 40 4 100
5 50 5 110 5 50 5 110 5 50 5 110
6 60 6 120 6 60 6 120 6 60 6 120
I have been trying with awk, but problems keep on recurring. Need help.