Create Macro to parse Spreadsheet
We have an excel document with one column that has a field with many attributes in one. I need a macro to properly split these attributes into columns so i can import that in properly.
You can see this column in the picture below . It has a specific structure. There are many attributes that are different for many of the rows. I need this column parsed into many rows
on one row you can see the data is the following
Type=Ethernet Switch|*|Form Factor=Rack-Mountable|*|Brand=3Com|*|MPN=3CR17251-91|*|Layer=3|*|Number of LAN Ports=48|*|Max. Data Transfer Rate=1000Mbps/1Gbps|*|Ethernet Technology=Gigabit Ethernet (1000-Mbit/s)
I would need the tool to split this field into many columns: the columns should be
Number of LAN Ports
Max. Data Transfer Rate