Shell Programming and Scripting

awk -F: '{a[row]=a[row]OFS$1; b[col]=b[col]OFS$2}END{print a[row]"\n"b[col]}' infile

bash-3.00$ cat mytxt3
Account name: admin
Role: admin
Description: Administrator
Enabled: Yes

Account name: user1
Role: operator
Description: System Operator
Enabled: Yes

Account name: bkpuser1
Role: backup
Description: Backup User
Enabled: Yes

bash-3.00$ awk -F: '{a[row]=a[row]OFS$1; b[col]=b[col]OFS$2}END{print a[row]"\n"b[col]}' mytxt3
Account name Role Description Enabled  Account name Role Description Enabled  Account name Role Description Enabled
admin  admin  Administrator  Yes   user1  operator  System Operator  Yes   bkpuser1  backup  Backup User  Yes

Account name Role       Description          Enabled
admin              admin     Administrator       Yes
user1              operator  System Operator  Yes
bkpuser1          backup    Backup User        Yes

awk -F': ' '{print $2}' infile | sed '/^$/d' | sed -n 'h;n;H;n;H;n;H;x;s/\n/ /g;p' | \
awk 'BEGIN{print "Account name Role Description Enabled"}{print $0}'

awk -F":" 'BEGIN{print " Account name Role Description Enabled"}{print $2,$4,$6,$8}" RS= file

Account name: bkpuser1
Role: backup
Description: Backup User
Allowed Capabilities: backup, restores, Create jobs  -- Some users have more than 5 capabilities
Enabled: Yes

Account Name, Role, Description, Allowed Capabilities, Enabled
bkpuser1,backup,Backup user,backup,Enabled
bkpuser1,backup,Backup user,restores,Enabled
bkpuser1,backup,Backup user,Create Jobs,Enabled
......other users.

awk -F":" 'BEGIN{print " Name, Info, Rid, Groups, Allowed Capabilities, Status"}{split ($8,a,","); for (i in length(a)) (print $2","$4","$6","$8","a[i]","$16} )' RS= mytxt2