Spreadsheet: 838374d1690971300-need-to-stack-multiple-uneven-columns-and-convert-formula-results-to-values-in-column-book1a
Sheet: Data2

Platform | Type H | Type S | Platform > Type > Subtype |  | Platform | 3rd Party Hardware | Platform | 3rd Party Software | Platform | Access Network Hardware | Platform | Access Network Software | Platform | Core Transmission Hardware | Platform | Core Transmission Software | Platform | Data Hardware | Platform | Data Software | Platform | IT Hardware | Platform | IT Software | Platform | LG - NL Hardware | Platform | Power Hardware | Platform | TV Hardware | Platform | TV Software | Platform | Voice Hardware | Platform | Voice Software
3rd Party | Hardware | Software | 3rd Party > Hardware > 3rd Party Hardware: |  | 3rd Party |  | 3rd Party |  | Access Network |  | Access Network |  | Core Transmission |  | Core Transmission |  | Data |  | Data |  | IT |  | IT |  | LG - NL |  | Power |  | TV |  | TV |  | Voice |  | Voice
Access Network | Hardware | Software | 3rd Party > Hardware > 3rd Party Power: | 3rd Party > Hardware > 3rd Party Power: | 3rd Party |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  | Data |  | IT |  | IT |  |  |  | Power |  | TV |  | TV |  | Voice |  | Voice
Core Transmission | Hardware | Software | 3rd Party > Software > 3rd Party Application: | 3rd Party > Software > 3rd Party Application: |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  | Data |  | IT |  | IT |  |  |  | Power |  | TV |  | TV |  | Voice |  | Voice
Data | Hardware | Software | Access Network > Hardware > Access-Eng-Mon-Laser chassis: | Access Network > Hardware > Access-Eng-Mon-Laser chassis: |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  | IT |  |  |  | Power |  | TV |  | TV |  | Voice
IT | Hardware | Software | Access Network > Hardware > Access-Eng-Mon-Moxa: | Access Network > Hardware > Access-Eng-Mon-Moxa: |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  | IT |  |  |  | Power |  | TV |  | TV |  | Voice
LG - NL | Hardware | Software | Access Network > Hardware > CATV Headend: | Access Network > Hardware > CATV Headend: |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  | IT |  |  |  | Power |  | TV |  |  |  | Voice
Power | Hardware | Software | Access Network > Hardware > CATV Node | Access Network > Hardware > CATV Node |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  | IT |  |  |  | Power |  | TV |  |  |  | Voice
TV | Hardware | Software | Access Network > Hardware > CWDM: | Access Network > Hardware > CWDM: |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  | IT |  |  |  | Power |  | TV |  |  |  | Voice
Voice | Hardware | Software | Access Network > Hardware > ECI Interface: | Access Network > Hardware > ECI Interface: |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  | IT |  |  |  | Power |  | TV |  |  |  | Voice
 | Hardware | Software | Access Network > Hardware > ECI: | Access Network > Hardware > ECI: |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  | IT |  |  |  | Power |  | TV |  |  |  | Voice
 | Hardware | Software | Access Network > Hardware > HFC Monitoring Equipment: | Access Network > Hardware > HFC Monitoring Equipment: |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  | IT |  |  |  | Power |  | TV |  |  |  | Voice
 | Hardware | Software | Access Network > Hardware > Interface: | Access Network > Hardware > Interface: |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  | IT |  |  |  |  |  | TV |  |  |  | Voice
 | Hardware | Software | Access Network > Hardware > L3 PON 2-Way Splitter | Access Network > Hardware > L3 PON 2-Way Splitter |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  | IT |  |  |  |  |  | TV |  |  |  | Voice
 | Hardware | Software | Access Network > Hardware > L3 PON 8-Way Splitter | Access Network > Hardware > L3 PON 8-Way Splitter |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  | IT |  |  |  |  |  | TV |  |  |  | Voice
 | Hardware | Software | Access Network > Hardware > L4 PON 4-Way Splitter | Access Network > Hardware > L4 PON 4-Way Splitter |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT |  |  |  |  |  |  |  |  |  |  |  | Voice
 | Hardware | Software | Access Network > Hardware > MSAN (Business): | Access Network > Hardware > MSAN (Business): |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT
 | Hardware | Software | Access Network > Hardware > Network DP | Access Network > Hardware > Network DP |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT
 | Hardware | Software | Access Network > Hardware > Network DP - FTTP | Access Network > Hardware > Network DP - FTTP |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data |  |  |  | IT
 | Hardware | Software | Access Network > Hardware > Network Fibre: | Access Network > Hardware > Network Fibre: |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data
 | Hardware | Software | Access Network > Hardware > Network Hub: | Access Network > Hardware > Network Hub: |  |  |  |  | Access Network |  |  |  | Core Transmission |  |  |  | Data
 | Hardware | Software | Access Network > Hardware > Network Interconnect: | Access Network > Hardware > Network Interconnect:
 | Hardware | Software | Access Network > Hardware > Network Node | Access Network > Hardware > Network Node
 | Hardware | Software | Access Network > Hardware > Network Other: | Access Network > Hardware > Network Other:
 | Hardware | Software | Access Network > Software > Broadgate (Access): | Access Network > Software > Broadgate (Access):
 | Hardware | Software | Core Transmission > Hardware > 3rd Party Cable: | Core Transmission > Hardware > 3rd Party Cable:
 | Hardware | Software | Core Transmission > Hardware > CIN Interface: | Core Transmission > Hardware > CIN Interface:
 | Hardware | Software | Core Transmission > Hardware > CIN: | Core Transmission > Hardware > CIN:
 | Hardware | Software | Core Transmission > Hardware > Cable | Core Transmission > Hardware > Cable
 | Hardware | Software | Core Transmission > Hardware > Ciena (ROADM) CPL: | Core Transmission > Hardware > Ciena (ROADM) CPL:
 | Hardware | Software | Core Transmission > Hardware > Ciena (ROADM) MPB: | Core Transmission > Hardware > Ciena (ROADM) MPB:
 | Hardware | Software | Core Transmission > Hardware > Ciena ROADM Interface: | Core Transmission > Hardware > Ciena ROADM Interface:
 | Hardware | Software | Core Transmission > Hardware > Ciena ROADM Test Lab: | Core Transmission > Hardware > Ciena ROADM Test Lab:
 | Hardware | Software | Core Transmission > Hardware > Ciena ROADM: | Core Transmission > Hardware > Ciena ROADM:
 | Hardware | Software | Core Transmission > Hardware > Core Replacement Project: | Core Transmission > Hardware > Core Replacement Project:
 | Hardware | Software | Core Transmission > Hardware > ECI Layer 20: | Core Transmission > Hardware > ECI Layer 20:
 | Hardware | Software | Core Transmission > Hardware > ECI Layer 21: | Core Transmission > Hardware > ECI Layer 21:
 | Hardware | Software | Core Transmission > Hardware > Fibre | Core Transmission > Hardware > Fibre
 | Hardware | Software | Core Transmission > Hardware > Nortel Layer 10 Interface: | Core Transmission > Hardware > Nortel Layer 10 Interface:
 | Hardware | Software | Core Transmission > Hardware > Nortel Layer 10: | Core Transmission > Hardware > Nortel Layer 10:
 | Hardware | Software | Core Transmission > Hardware > PTP CIN Clock [NAME]: | Core Transmission > Hardware > PTP CIN Clock [NAME]:
 | Hardware | Software | Core Transmission > Hardware > PTP CIN Clock: | Core Transmission > Hardware > PTP CIN Clock:
 | Hardware | Software | Core Transmission > Hardware > SASE: | Core Transmission > Hardware > SASE:
 | Hardware | Software | Core Transmission > Hardware > Server: | Core Transmission > Hardware > Server:
 | Hardware | Software | Core Transmission > Hardware > Site Infrastructure: | Core Transmission > Hardware > Site Infrastructure:
 | Hardware | Software | Core Transmission > Software > Broadgate (Core): | Core Transmission > Software > Broadgate (Core):
 | Hardware | Software | Data > Hardware > AFTR: | Data > Hardware > AFTR:
 | Hardware | Software | Data > Hardware > Aggregation [NAME]: | Data > Hardware > Aggregation [NAME]:
 | Hardware | Software | Data > Hardware > Aggregation Switch: | Data > Hardware > Aggregation Switch:
 | Hardware | Software | Data > Hardware > BAG Interface: | Data > Hardware > BAG Interface:
 | Hardware | Software | Data > Hardware > BAG: | Data > Hardware > BAG:
 | Hardware |  | Data > Hardware > BAM Interface: | Data > Hardware > BAM Interface:
 | Hardware |  | Data > Hardware > BAM: | Data > Hardware > BAM:
 | Hardware |  | Data > Hardware > BCIN-rPHY: | Data > Hardware > BCIN-rPHY:
 | Hardware |  | Data > Hardware > BNG Card: | Data > Hardware > BNG Card:
 | Hardware |  | Data > Hardware > BNG Interface: | Data > Hardware > BNG Interface:
 | Hardware |  | Data > Hardware > BNG: | Data > Hardware > BNG:
 | Hardware |  | Data > Hardware > BPX: | Data > Hardware > BPX:
 | Hardware |  | Data > Hardware > BT Circuit Migration: | Data > Hardware > BT Circuit Migration:
 | Hardware |  | Data > Hardware > Backbone (Virgin Media UK) Interface: | Data > Hardware > Backbone (Virgin Media UK) Interface:
 | Hardware |  | Data > Hardware > Backbone (Virgin Media UK): | Data > Hardware > Backbone (Virgin Media UK):
 | Hardware |  | Data > Hardware > Belfast Project: | Data > Hardware > Belfast Project:
 | Hardware |  | Data > Hardware > Brix: | Data > Hardware > Brix:
 | Hardware |  | Data > Hardware > Business Essentials Dev: | Data > Hardware > Business Essentials Dev:
 | Hardware |  | Data > Hardware > C20 Geo-Res: | Data > Hardware > C20 Geo-Res:
 | Hardware |  | Data > Hardware > CCV: | Data > Hardware > CCV:
 | Hardware |  | Data > Software > 3rd Party Application: | Data > Software > 3rd Party Application:
 | Hardware |  | Data > Software > Application Software: | Data > Software > Application Software:
 | Hardware |  | Data > Software > Company App: | Data > Software > Company App:
 | Hardware |  | IT > Hardware > 3rd Party Hardware: | IT > Hardware > 3rd Party Hardware:
 | Hardware |  | IT > Hardware > Cluster Service: | IT > Hardware > Cluster Service:
 | Hardware |  | IT > Hardware > Cluster: | IT > Hardware > Cluster:
 | Hardware |  | IT > Hardware > Disk Array: | IT > Hardware > Disk Array:
 | Hardware |  | IT > Hardware > EUC Devices: | IT > Hardware > EUC Devices:
 | Hardware |  | IT > Hardware > Empirix: | IT > Hardware > Empirix:
 | Hardware |  | IT > Hardware > Gateway - VPN: | IT > Hardware > Gateway - VPN:
 | Hardware |  | IT > Hardware > HMC: | IT > Hardware > HMC:
 | Hardware |  | IT > Hardware > IL3: | IT > Hardware > IL3:
 | Hardware |  | IT > Hardware > Load Balancer: | IT > Hardware > Load Balancer:
 | Hardware |  | IT > Hardware > Media Library: | IT > Hardware > Media Library:
 | Hardware |  | IT > Hardware > Mobile Hardware: | IT > Hardware > Mobile Hardware:
 | Hardware |  | IT > Hardware > Network Device (Contained): | IT > Hardware > Network Device (Contained):
 | Hardware |  | IT > Hardware > Network Device: | IT > Hardware > Network Device:
 | Hardware |  | IT > Hardware > Network Security Device: | IT > Hardware > Network Security Device:
 | Hardware |  | IT > Hardware > OSS CAT | IT > Hardware > OSS CAT
 | Hardware |  | IT > Hardware > Server-BladeEnclosure: | IT > Hardware > Server-BladeEnclosure:
 | Hardware |  | IT > Hardware > Server-Hypervisor: | IT > Hardware > Server-Hypervisor:
 | Hardware |  | IT > Software > Application: | IT > Software > Application:
 | Hardware |  | IT > Software > Database: | IT > Software > Database:
 | Hardware |  | IT > Software > Desktop App.: | IT > Software > Desktop App.:
 | Hardware |  | IT > Software > GCP Application: | IT > Software > GCP Application:
 | Hardware |  | IT > Software > GCP Dataset: | IT > Software > GCP Dataset:
 | Hardware |  | IT > Software > GCP Project: | IT > Software > GCP Project:
 | Hardware |  | IT > Software > GCP Storage Bucket: | IT > Software > GCP Storage Bucket:
 | Hardware |  | IT > Software > Load Balancer-VIP: | IT > Software > Load Balancer-VIP:
 | Hardware |  | IT > Software > Mobile Software: | IT > Software > Mobile Software:
 | Hardware |  | IT > Software > Off-The-Shelf-Software: | IT > Software > Off-The-Shelf-Software:
 | Hardware |  | IT > Software > Operations Routine: | IT > Software > Operations Routine:
 | Hardware |  | IT > Software > Platform: | IT > Software > Platform:
 | Hardware |  | IT > Software > Portal: | IT > Software > Portal:
 | Hardware |  | IT > Software > Web Service: | IT > Software > Web Service:
 | Hardware |  | LG - NL > Hardware > Server: | LG - NL > Hardware > Server:
 | Hardware |  | Power > Hardware > AIR: | Power > Hardware > AIR:
 | Hardware |  | Power > Hardware > Chiller: | Power > Hardware > Chiller:
 | Hardware |  | Power > Hardware > DCS: | Power > Hardware > DCS:
 | Hardware |  | Power > Hardware > FSS | Power > Hardware > FSS
 | Hardware |  | Power > Hardware > Generator: | Power > Hardware > Generator:
 | Hardware |  | Power > Hardware > HPI: | Power > Hardware > HPI:
 | Hardware |  | Power > Hardware > Hybrid: | Power > Hardware > Hybrid:
 | Hardware |  | Power > Hardware > LVS | Power > Hardware > LVS
 | Hardware |  | Power > Hardware > SCADA | Power > Hardware > SCADA
 | Hardware |  | Power > Hardware > Site Infrastructure | Power > Hardware > Site Infrastructure
 | Hardware |  | Power > Hardware > UPS: | Power > Hardware > UPS:
 | Hardware |  | TV > Hardware > Arris: | TV > Hardware > Arris:
 | Hardware |  | TV > Hardware > Assurance Probe: | TV > Hardware > Assurance Probe:
 | Hardware |  | TV > Hardware > Atlas: | TV > Hardware > Atlas:
 | Hardware |  | TV > Hardware > Axiom Command Centre: | TV > Hardware > Axiom Command Centre:
 | Hardware |  | TV > Hardware > Axiom Video Servers: | TV > Hardware > Axiom Video Servers:
 | Hardware |  | TV > Hardware > BlackArrow: | TV > Hardware > BlackArrow:
 | Hardware |  | TV > Hardware > Broadcast Platform: | TV > Hardware > Broadcast Platform:
 | Hardware |  | TV > Hardware > CDN Service: | TV > Hardware > CDN Service:
 | Hardware |  | TV > Hardware > CPE: | TV > Hardware > CPE:
 | Hardware |  | TV > Hardware > Cabling: | TV > Hardware > Cabling:
 | Hardware |  | TV > Hardware > Cardless | TV > Hardware > Cardless
 | Hardware |  | TV > Hardware > Control Panel: | TV > Hardware > Control Panel:
 | Hardware |  | TV > Hardware > Copernicus: | TV > Hardware > Copernicus:
 | Hardware |  | TV > Hardware > D9815 Chassis: | TV > Hardware > D9815 Chassis:
 | Hardware |  | TV > Software > Adrenalin: | TV > Software > Adrenalin:
 | Hardware |  | TV > Software > Alternate TV Channel | TV > Software > Alternate TV Channel
 | Hardware |  | TV > Software > Application Software: | TV > Software > Application Software:
 | Hardware |  | TV > Software > TV Channel | TV > Software > TV Channel
 | Hardware |  | TV > Software > TV Transport Stream | TV > Software > TV Transport Stream
 | Hardware |  | Voice > Hardware > CCMIS: | Voice > Hardware > CCMIS:
 | Hardware |  | Voice > Hardware > Desktop PC: | Voice > Hardware > Desktop PC:
 | Hardware |  | Voice > Hardware > ECT: | Voice > Hardware > ECT:
 | Hardware |  | Voice > Hardware > FAM: | Voice > Hardware > FAM:
 | Hardware |  | Voice > Hardware > ICM: | Voice > Hardware > ICM:
 | Hardware |  | Voice > Hardware > IMS Node: | Voice > Hardware > IMS Node:
 | Hardware |  | Voice > Hardware > IP Voice Switch: | Voice > Hardware > IP Voice Switch:
 | Hardware |  | Voice > Hardware > IVR: | Voice > Hardware > IVR:
 | Hardware |  | Voice > Hardware > JOAN [NAME] | Voice > Hardware > JOAN [NAME]
 | Hardware |  | Voice > Hardware > M3: | Voice > Hardware > M3:
 | Hardware |  | Voice > Hardware > Metaswitch: | Voice > Hardware > Metaswitch:
 | Hardware |  | Voice > Hardware > NIVR: | Voice > Hardware > NIVR:
 | Hardware |  | Voice > Hardware > RCU: | Voice > Hardware > RCU:
 | Hardware |  | Voice > Hardware > RSS: | Voice > Hardware > RSS:
 | Hardware |  | Voice > Hardware > Router: | Voice > Hardware > Router:
 | Hardware |  | Voice > Software > Application Software: | Voice > Software > Application Software:
 | Hardware |  | Voice > Software > Database: | Voice > Software > Database:
 | Hardware |  | Voice > Software > Desktop Application: | Voice > Software > Desktop Application:
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware
 | Hardware