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


Form Factor




Number of LAN Ports

Max. Data Transfer Rate

Ethernet Technology

Taidot: C-ohjelmointi, tiedonsyöttö, tietojenkäsittely, Excel, Python

Näytä lisää: parse data in excel vba, excel macro to parse, macro to parse data in excel, excel macro locks spreadsheet, create macro import text file excel 2003, create csv excel spreadsheet, macro filling spreadsheet, create macro solidworks, macro lock spreadsheet size, create macro outlook 2007 dial contact, automatically create macro outlook, create macro email completed word document, create macro cut paste data, create appointment email macro parse, macro data spreadsheet, create macro cut paste web database, create macro wordperfect, create macro outlook 2003

Tietoa työnantajasta:
( 10 arvostelua ) philadelphia, United States

Projektin tunnus: #16709249

Myönnetty käyttäjälle:


Hello. the budget down. Please contact me ! .

$50 USD 1 päivässä
(89 Arvostelua)

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD 2 päivässä
(249 arvostelua)

sir i can do it in 10 min please pm...............sir i can do it in 10 min please pm...............sir i can do it in 10 min please pm...............

$25 USD 1 päivässä
(177 arvostelua)
$25 USD 0 päivässä
(353 arvostelua)

Hello I'm a software engineering student and an experienced C dev please contact me over chat for more details.

$40 USD 1 päivässä
(29 arvostelua)

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on I am ready to carry out your project in the reasonable price and in the shortest possibl Lisää

$50 USD 0 päivässä
(18 arvostelua)

hello. how are you? i am expert of python, Microsoft Word,Microsoft Excel, excel VBA and data Scraping. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best r Lisää

$25 USD 1 päivässä
(24 arvostelua)
$40 USD 1 päivässä
(1 arvostelu)

Hai this is Gajendran, I’m having good experience in Web Searching & Macro's. Based on your project description I can easily take those details with in a day and provide you the best data, will complete this task withi Lisää

$20 USD 0 päivässä
(5 arvostelua)

I can work as fast as possible as I am very familiar and uses Microsoft Excel on a daily basis. I am new here but I can assure you that my work is with quality results. This project would be a very good project to star Lisää

$25 USD 1 päivässä
(0 arvostelua)

Hello, I was working previously at Airbus mainly on Microsoft technologies, and especially Excel I wrote a lot of Macro and I can help you quickly

$25 USD 1 päivässä
(1 arvostelu)

No I would create the macro in 1 day or less with no issues.

$25 USD 1 päivässä
(0 arvostelua)