Convert single column into multiple rows

Shell Programming and Scripting
1

Convert Single column to multiple rows
file a.txt contains data like below

Server=abc
Run=1
Tables=10
Sessions=16
Time=380
Jobs=5
Server=abc
Run=2
Tables=15
Sessions=16
Time=400
Jobs=5
Server=abc
Run=3
Tables=20
Sessions=16
Time=450
Jobs=5

I am interested in only printing following values, Server is the breaker for the columns

Server abc abc abc
Run 1 2 3
Tables 10 15 20
Time 380 400 450

I am thinking like

report=" Server Run Tables Time "
for i in $report 
do
cat a.txt | awk -v search="$i" -F"=" '/search/ {print $1 $2}'
done

How can I do this?

2

Would this work

sort  a.txt | awk -F'=' 'BEGIN {l=null} {if($1 != l ) {l=$1; printf("\n%s ",$1)} else { printf("%s ",$2)}}'
3

thanks, but it is skipping the first instance, and I would like only the one from the list
report=" Server Run Tables Time "

Jobs 5 5
Run 2 3
Server abc abc
Sessions 16 16
Tables 15 20
4

Sorry, I don't understand. Are you saying you want it in that order?

5

Yes, only those variables in the
report=" Server Run Tables Time "

6

ok, I get it
Here you go

sort a.txt | awk -F'=' 'BEGIN {l=null} $1 ~ /Time|Server|Run|Tables/ {if($1 != l ) {l=$1; printf("\n%s ",$1)} else { printf("%s ",$2)}}'
1 Like