Spreadsheet: 777755d1650582013-complicated-multiple-rows-and-columns-to-re-format-into-columns-book3
Sheet: Sheet1

CURRENT INFO PROVIDED AS FOLLOWS |  |  |  | HOW I WOULD LIKE IT TO LOOK
HOSTNAME | SITE ID | SITE NAME |  | Site ID | Interface VlanX | Interface VlanX mask | Interface VlanX secondary | Interface VlanX secondary mask | Interface VlanX secondary | Interface VlanX secondary mask | interface VlanXX | Interface VlanXX mask
 |  |  |  | 1234 | 1.1.1.1 | 255.255.255.240 |  |  |  |  | 2.2.2.2 | 255.255.255.224
router_name_varying_length_1 | 1234 | abc 1234 |  | 234 | 4.4.4.4 | 255.255.255.240 | 3.3.3.3 | 255.255.255.252 |  |  | 5.5.5.5 | 255.255.255.224
 |  |  |  | 2345 | 4.4.4.4 | 255.255.255.240 | 3.3.3.3 | 255.255.255.252 |  |  | 5.5.5.5 | 255.255.255.224
interface VlanX |  |  |  | 3456 | 4.4.4.4 | 255.255.255.240 | 3.3.3.3 | 255.255.255.252 |  |  | 5.5.5.5 | 255.255.255.224
1.1.1.1 255.255.255.240 |  |  |  | 4567 | 4.4.4.4 | 255.255.255.240 | 3.3.3.3 | 255.255.255.252 | 6.6.6.6 | 255.255.255.240 | 5.5.5.5 | 255.255.255.224
interface VlanXX |  |  |  | 5678 | 4.4.4.4 | 255.255.255.240 | 3.3.3.3 | 255.255.255.252 |  |  | 5.5.5.5 | 255.255.255.224
2.2.2.2 255.255.255.224 |  |  |  | 6789 | 4.4.4.4 | 255.255.255.240 | 3.3.3.3 | 255.255.255.252 |  |  | 5.5.5.5 | 255.255.255.224
 |  |  |  | 7890 | 4.4.4.4 | 255.255.255.240 | 3.3.3.3 | 255.255.255.252 |  |  | 5.5.5.5 | 255.255.255.224
___________________________________________________________________________ |  |  |  | 890 | 4.4.4.4 | 255.255.255.240 | 3.3.3.3 | 255.255.255.252 |  |  | 5.5.5.5 | 255.255.255.224
 |  |  |  | 9012 | 4.4.4.4 | 255.255.255.240 | 3.3.3.3 | 255.255.255.252 |  |  | 5.5.5.5 | 255.255.255.224
router_name_varying_length_2 | 234 | abc 234 |  | 0123 | 4.4.4.4 | 255.255.255.240 | 3.3.3.3 | 255.255.255.252 |  |  | 5.5.5.5 | 255.255.255.224
interface VlanX
3.3.3.3 255.255.255.252 secondary
4.4.4.4 255.255.255.240
interface VlanXX
5.5.5.5 255.255.255.224
___________________________________________________________________________
router_name_varying_length_3 | 2345 | abc 2345
interface VlanX
3.3.3.3 255.255.255.252 secondary
4.4.4.4 255.255.255.240
interface VlanXX
5.5.5.5 255.255.255.224
___________________________________________________________________________
router_name_varying_length_4 | 3456 | abc 3456
interface VlanX
3.3.3.3 255.255.255.252 secondary
4.4.4.4 255.255.255.240
interface VlanXX
5.5.5.5 255.255.255.224
___________________________________________________________________________
router_name_varying_length_5 | 4567 | abc 4567
interface VlanX
3.3.3.3 255.255.255.252 secondary
6.6.6.6 255.255.255.240 secondary
4.4.4.4 255.255.255.240
interface VlanXX
5.5.5.5 255.255.255.224
___________________________________________________________________________
router_name_varying_length_6 | 5678 | abc 5678
interface VlanX
3.3.3.3 255.255.255.252 secondary
4.4.4.4 255.255.255.240
interface VlanXX
5.5.5.5 255.255.255.224
___________________________________________________________________________
router_name_varying_length_7 | 6789 | abc 6789
interface VlanX
3.3.3.3 255.255.255.252 secondary
4.4.4.4 255.255.255.240
interface VlanXX
5.5.5.5 255.255.255.224
___________________________________________________________________________
router_name_varying_length_8 | 7890 | abc 7890
interface VlanX
3.3.3.3 255.255.255.252 secondary
4.4.4.4 255.255.255.240
interface VlanXX
5.5.5.5 255.255.255.224
___________________________________________________________________________
router_name_varying_length_9 | 890 | abc 890
interface VlanX
3.3.3.3 255.255.255.252 secondary
4.4.4.4 255.255.255.240
interface VlanXX
5.5.5.5 255.255.255.224
___________________________________________________________________________
router_name_varying_length_10 | 9012 | abc 9012
interface VlanX
3.3.3.3 255.255.255.252 secondary
4.4.4.4 255.255.255.240
interface VlanXX
5.5.5.5 255.255.255.224
___________________________________________________________________________
router_name_varying_length_11 | 0123 | abc 0123
interface VlanX
3.3.3.3 255.255.255.252 secondary
4.4.4.4 255.255.255.240
interface VlanXX
5.5.5.5 255.255.255.224
___________________________________________________________________________