Rows into Columns

Input File

 
vCenter Servers: 
  172.28.173.207: 
    vCenter Server connectivity status: Accessible
    ESX servers: 
      Name: nyp-vhst1001-at.hq.nt.life.com
      IP address: 10.34.36.11
      Virtual machines: 
        Name:nyp-bbmds-at
        Ip address: 172.28.173.139
        Protection state: Not protected
        Protected by group:N/A
        Data stores: 
          Name: ADC-VMLUN-CLANRP-06
          Volumes: 
            Name: naa.60060160084f2200102e4b030f2edf11
            Group info:N/A
            Volume details:N/A
        RDM devices: None
        Name: nyp-vfldc01-at
        Ip address: 172.28.175.247
        Protection state: Fully protected
        Protected by group: 0916 to 2450 vmware
        Data stores: 
          Name: ADC-DC-CLAREP-01
          Volumes: 
            Name: naa.60060160017b2500942e4561bc3ee011
            Group info: [0916 to 2450 vmware, ADC R1, RSet 1]
            Volume details:
              512.00GB  DGC  VRAID  CX4-960  ADC-DC-CLANREP-01 (148)  
        RDM devices: None
        Non-VM volumes: 
        Name: naa.50060160bb20135c50060160bb20135c
        Group info:N/A
        Volume details:N/A
 
        Name: naa.60060160017b25004c3797e1733fe011
        Group info: [0916 to 2450 vmware, ADC R1, RSet 4]
        Volume details:
          512.00GB  DGC  VRAID  CX4-960  ADC-DC-CLANREP-02 (153)  
 
        Name: naa.60060160017b25008610e38ae227e011
        Group info: [0916 to 2450 vmware, ADC R1, RSet 2]
        Volume details:
          1.00TB  DGC  VRAID  CX4-960  ADC-P2V-CLANREP-08 (104)

Need two Output files

Virtual machines :

ESX Server,Guest Host,Protected by Group,Protection Status,Data Store,Volume Size,Group Info
nyp-vhst1001-at.hq.nt.life.com,nyp-bbmds-at,N/A,Not protected,ADC-VMLUN-CLANRP-06,N/A,N/A
nyp-vhst1001-at.hq.nt.life.com,nyp-vfldc01-at,0916 to 2450 vmware,Fully protected,ADC-DC-CLAREP-01,512.00,RSet 1

Non-VM volumes:

 
ESX Server,Group Name,Group Info,Volume Size
nyp-vhst1001-at.hq.nt.life.com,0916 to 2450 vmware,512.00,RSet 4
 

For Non-VM , only want the volumes where Group Info is not N/A

Thanks

using AWK arrays maybe ,, i am new to them ... thx