Separating one long column into many

[hll22]

I'm a total beginner, I know this is probably a very simple task but as I have no experience, I don't know how to do this. I have a file, one long column of values, I want to separate it into 2 columns so just the first 100 values in the first column and the second 100 values in the second column...how do I do this?

 

[Mag0007]

hope this helps

awk 'BEGIN {i=0;j=0} {  if (j==10) {print $0,"split"; i++; j=0} j++ } END {print i}'  data

 

[olded]

How about a non-awk solution:

cat data|xargs -n 100

 

[hll22]

thank you! The cat line works, but it makes it into two lines of 100 values instead of 2 columns of 100 lines.

 

[olded]

Then, how about:

cat data|xargs -n 2