convert column into row

Question

I have file

I want to convert the second column into row

head desired

12
0
9
3
12
0
12
0
12
0
7
5

Thanks

score 7 · Answer 1 · answered Jul 13 '18 at 22:18

7

An easy job for tr:

$ cat input | tr ' ' '\n'
12
0
9
3
12
0
12
0
12
0
12
0
7
5

answered Jul 13 '18 at 22:18

DopeGhoti

score 3 · Accepted Answer · answered Jul 13 '18 at 22:16

3

You can use awk on this.

 awk '{for(i=1;i<=NF;i++) printf "%s\n",$i}' input.txt

answered Jul 13 '18 at 22:16

Zombo · Answer 3 · 2018-07-14T11:51:19.013

2

Some other options:

fmt -0 file1

Or:

xargs -n 1 < file1

edited Jul 14 '18 at 11:51

answered Jul 13 '18 at 23:52

Zombo

score 1 · Answer 4 · answered Jul 13 '18 at 22:18

1

tr -s '[:blank:]' '\n' < file

or

awk 'BEGIN{RS="[ \t\n]+"} 1' file

answered Jul 13 '18 at 22:18

steeldriver

This awk didn't work for me on Mac ( which is BSD awk I guess ), so might be GNU awk specific. – Sergiy Kolodyazhnyy Jul 13 '18 at 22:27

score 1 · Answer 5 · answered Jul 13 '18 at 22:48

1

Using xargs:

xargs -n1 < <(head input)

Or you could take advantage of the shells word splitting:

printf '%s\n' $(head input)

answered Jul 13 '18 at 22:48

jesse_b

5 Answers5