Find Jobs
Hire Freelancers

Create Macro to parse Spreadsheet

$10-30 USD

Completed
Posted almost 6 years ago

$10-30 USD

Paid on delivery
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
Project ID: 16709249

About the project

11 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello. the budget down. Please contact me ! .
$50 USD in 1 day
4.9 (108 reviews)
6.9
6.9
11 freelancers are bidding on average $34 USD for this job
User Avatar
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 in 1 day
5.0 (271 reviews)
7.1
7.1
User Avatar
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 in 2 days
4.9 (306 reviews)
7.3
7.3
User Avatar
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Excel, of course, familiar. Give me a chance to show what I can do!
$50 USD in 0 day
5.0 (58 reviews)
5.8
5.8
User Avatar
Hello I'm a software engineering student and an experienced C dev please contact me over chat for more details.
$40 USD in 1 day
4.7 (33 reviews)
5.1
5.1
User Avatar
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 within time limits. I’m interested in your project, kindly give an opportunity to do the same. Thanks in advance.
$20 USD in 0 day
5.0 (22 reviews)
3.4
3.4
User Avatar
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 start with. Thank you
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
4.2 (1 review)
0.2
0.2
User Avatar
No I would create the macro in 1 day or less with no issues.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
philadelphia, United States
5.0
19
Payment method verified
Member since Jan 20, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.