UNIX for Dummies Questions & Answers

dears

i have row data as below:

========================================================================================
Session Count: 24580
Session Count: 13426
Session Count: 22533
Session Count: 0
Session Count: 0
Session Count: 15036
Session Count: 11625
Session Count: 6942
Session Count: 11958
Session Count: 25082
Session Count: 22489
======================================================
Session Count: 24354
Session Count: 13457
Session Count: 22425
Session Count: 0
Session Count: 0
Session Count: 14913
Session Count: 11553
Session Count: 6810
Session Count: 11714
Session Count: 24920
Session Count: 22212
=======================================================


and i want to make the output like this:


Session Count: Session Count: Session Count: Session Count: Session Count: Session Count: Session Count: Session Count: Session Count: Session Count: Session Count:
24580 13426 22533 0 0 15036 11625 6942 11958 25082 22489
============== ==========================================================================
Session Count: Session Count: Session Count: Session Count: Session Count: Session Count: Session Count: Session Count: Session Count: Session Count: Session Count:
24354 13457 22425 0 0 14913 11553 6810 11714 24920 22212
============== ==========================================================================

so any one can help me in getting a script can do this?

thank you

Try:

Code:

awk -F': ' '/^=/{print p ORS q ORS $0;p=q=x;next}{p=p $1 FS;q=q $2 OFS}' infile

-or-

Code:

awk -F ': ' 'NR==1{next}/^=/{print p ORS q ORS $0;p=q=x;next}{p=p $1 FS;q=q $2 OFS}' infile

greaaaaat wrok thank you

I have posted a matrix transpose script here few days ago:
https://www.unix.com/shell-programmin...into-rows.html

Code:

#!/bin/bash 
 
transpose() 
{ 
  awk ' 
      { 
              if (max_nf<NF) 
                    max_nf=NF 
              max_nr=NR 
              for (x=1; x<=NF; ++x) 
                     vector[x, NR]=$x 
      } 
  END { 
              for (x=1; x<=max_nf; ++x) { 
                   for (y=1; y<=max_nr; ++y) 
                        printf("%s ", vector[x, y]) 
                   printf("\n") 
               } 
          }'  ${1} 
} 
 
transpose ${1}