Spreadsheet: 777868d1650644292-complicated-multiple-rows-and-columns-to-re-format-into-columns-book4
Sheet: Sheet1

CURRENT INFO PROVIDED AS FOLLOWS |  |  |  | HOW I WOULD LIKE IT TO LOOK
HOSTNAME | SITE ID | SITE NAME |  | Site ID | VLAN20 | VLAN20 MASK | VLAN30 | VLAN30 MASK | VLAN40 | VLAN40 MASK | VLAN50 | VLAN50 MASK | VLAN60 | VLAN60 MASK
 |  |  |  | 123 | 1.1.1.1 | 255.255.255.128 | 2.2.2.2 | 255.255.255.128 | 3.3.3.3 | 255.255.255.192 | 4.4.4.4 | 255.255.255.128
 | 123 | SITE 1 |  | 1234 | 1.1.1.1 | 255.255.255.128 | 2.2.2.2 | 255.255.255.128 | 3.3.3.3 | 255.255.255.192 | 4.4.4.4 | 255.255.255.128
 |  |  |  | 3456 | 1.1.1.1 | 255.255.255.128 | 2.2.2.2 | 255.255.255.128 | 3.3.3.3 | 255.255.255.192 | 4.4.4.4 | 255.255.255.128
interface Vlan20 |  |  |  | 4567 | 1.1.1.1 | 255.255.255.128 | 2.2.2.2 | 255.255.255.128 | 3.3.3.3 | 255.255.255.192 | 4.4.4.4 | 255.255.255.128
ip address 1.1.1.1 255.255.255.128 |  |  |  | 5678 | 1.1.1.1 | 255.255.255.128 | 2.2.2.2 | 255.255.255.128 | 3.3.3.3 | 255.255.255.192 | 4.4.4.4 | 255.255.255.128
interface Vlan30 |  |  |  | 6789 | 1.1.1.1 | 255.255.255.128 | 2.2.2.2 | 255.255.255.128 | 3.3.3.3 | 255.255.255.192 | 4.4.4.4 | 255.255.255.128
ip address 2.2.2.2 255.255.255.128 |  |  |  | 7890 | 1.1.1.1 | 255.255.255.128 | 2.2.2.2 | 255.255.255.128 | 3.3.3.3 | 255.255.255.192 | 4.4.4.4 | 255.255.255.128 | 5.5.5.5 | 255.255.255.128
interface Vlan40
ip address 3.3.3.3 255.255.255.192
interface Vlan50
ip address 4.4.4.4 255.255.255.128
interface Vlan1
no ip address
___________________________________________________________________________
 | 1234 | SITE ABC
interface Vlan20
ip address 1.1.1.1 255.255.255.128
interface Vlan30
ip address 2.2.2.2 255.255.255.128
interface Vlan40
ip address 3.3.3.3 255.255.255.192
interface Vlan50
ip address 4.4.4.4 255.255.255.128
interface Vlan1
no ip address
___________________________________________________________________________
 | 3456 | SITE TEST
interface Vlan20
ip address 1.1.1.1 255.255.255.128
interface Vlan30
ip address 2.2.2.2 255.255.255.128
interface Vlan40
ip address 3.3.3.3 255.255.255.192
interface Vlan50
ip address 4.4.4.4 255.255.255.128
interface Vlan1
no ip address
___________________________________________________________________________
 | 4567 | SITE 4
interface Vlan20
ip address 1.1.1.1 255.255.255.128
interface Vlan30
ip address 2.2.2.2 255.255.255.128
interface Vlan40
ip address 3.3.3.3 255.255.255.192
interface Vlan50
ip address 4.4.4.4 255.255.255.128
interface Vlan1
no ip address
___________________________________________________________________________
 | 5678 | SITE 5
interface Vlan20
ip address 1.1.1.1 255.255.255.128
interface Vlan30
ip address 2.2.2.2 255.255.255.128
interface Vlan40
ip address 3.3.3.3 255.255.255.192
interface Vlan50
ip address 4.4.4.4 255.255.255.128
interface Vlan1
no ip address
___________________________________________________________________________
 | 6789 | SITE DIFF
interface GigabitEthernet0/0/0.20
ip address 1.1.1.1 255.255.255.128
interface [NAME]
ip address 2.2.2.2 255.255.255.192
interface GigabitEthernet0/0/0.40
ip address 3.3.3.3 255.255.255.192
interface GigabitEthernet0/0/0.50
ip address 4.4.4.4 255.255.255.128
 | 7890 | SITE ALT
interface Vlan20
ip address 1.1.1.1 255.255.255.128
interface Vlan30
ip address 2.2.2.2 255.255.255.128
interface Vlan40
ip address 3.3.3.3 255.255.255.192
interface Vlan50
ip address 4.4.4.4 255.255.255.128
interface Vlan60
ip address 5.5.5.5 255.255.255.128
interface Vlan1
no ip address