Create Macro to parse Spreadsheet

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 Type Form Factor Brand MPN Layer Number of LAN Ports Max. Data Transfer Rate Ethernet Technology