Find Jobs
Hire Freelancers

Need to Parse Excel Sheet

$30-250 USD

Закрито
Опублікований almost 6 years ago

$30-250 USD

Оплачується при отриманні
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
ID проекту: 16709157

Про проект

43 пропозицій(-ї)
Дистанційний проект
Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
43 фрілансерів(-и) готові виконати цю роботу у середньому за $88 USD
Аватарка користувача
Hello, My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Thanks, Jay
$250 USD за 3 дні(-в)
5,0 (831 відгуки(-ів))
8,9
8,9
Аватарка користувача
Hi, my name is Sevinc. I checked your columns structure, I can write a macro for you to fix it in 1-day as per your needs. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$100 USD за 1 день
4,9 (363 відгуки(-ів))
8,3
8,3
Аватарка користувача
Hello, I have the good knowledge of Need to Parse Excel Sheet. I have more than 5 years of experience in Data Entry, Data Mining, Data Processing, Excel, Python. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$180 USD за 3 дні(-в)
4,9 (509 відгуки(-ів))
8,4
8,4
Аватарка користувача
Hi there, I just checked the project details and i'm very interested to discuss with you. I have great knowledge in excel formula and macros. Feel free to pm so that we can discuss and share sample work! Regards. Sohan D.
$50 USD за 1 день
5,0 (376 відгуки(-ів))
8,0
8,0
Аватарка користувача
Hi there, we can do this by excel formula instead of other script. we can get you the result very quickly. this job is our daily task. Thank you
$59 USD за 1 день
4,9 (387 відгуки(-ів))
8,3
8,3
Аватарка користувача
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.
$100 USD за 3 дні(-в)
5,0 (486 відгуки(-ів))
8,0
8,0
Аватарка користувача
I read and understood your requirements - Need to Parse Excel Sheet and can do as instructed. So i hope you would open a PM to discuss about the work . Regards, Ponsi
$100 USD за 2 дні(-в)
5,0 (448 відгуки(-ів))
7,9
7,9
Аватарка користувача
Hi, there. I just read your brief and it sounds very interesting. My name's Paris Pallas and I'm a very experienced VBA developer. I've developed hundreds of projects integrating code into MS Office apps such as Excel, Word, Access, and PowerPoint. I'm really interested in your project. I strongly suggest using a macro that will split the contents of each cell into separate columns (Type, Form Factor, Brand, MPN, Layer, Number of LAN Ports, Max. Data Transfer Rate, and Ethernet Technology). I can start right away and deliver within a couple of hours! Please, let me know if this is something you find interesting and would like to know more about it. Regards
$50 USD за 0 день
4,9 (375 відгуки(-ів))
8,1
8,1
Аватарка користувача
Dear Sir/Ma'am, I have good experience in parse excel data I can do samples to show you kindly PM me to discuss further. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$50 USD за 1 день
4,9 (440 відгуки(-ів))
8,1
8,1
Аватарка користувача
I have the knowledge and experience to implement your need on Microsoft Excel and VBA. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application, scripting including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I offer you 35+ years of experience working in a variety of companies including, VC's, privet investors, entrepreneurs, startups, marine and land transportation, retailers, power plants, farms, insurance, universities, real estate & constructions, medical equipment manufacturer, among others.
$250 USD за 3 дні(-в)
4,9 (95 відгуки(-ів))
7,5
7,5
Аватарка користувача
Dear client I have previously carried out a number of projects in excel using macros and formulas. I understand the scope of work in this project and i certainly believe I can help you in this project. Kindly contact me Roy
$100 USD за 2 дні(-в)
4,9 (479 відгуки(-ів))
7,4
7,4
Аватарка користувача
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$70 USD за 2 дні(-в)
4,9 (120 відгуки(-ів))
7,1
7,1
Аватарка користувача
This can be easily done using Excel VBA. I can help you find the most efficient way. Feel free to contact me for details.
$33 USD за 2 дні(-в)
4,9 (220 відгуки(-ів))
7,0
7,0
Аватарка користувача
Hello. I'm a vb.net programmer. Vb is the language used by excel. I will write a script which you can run anytime, in order to split the cells and add the values to the columns. It will be able to automatically create new columns when new values and field names are found. I can start today and have it ready within 1 day.
$77 USD за 1 день
5,0 (196 відгуки(-ів))
7,0
7,0
Аватарка користувача
Hi: I can create a macro that will take the Excel file as input and generate the output will data split into multiple columns. I would like to highlight that I have over 7 years of experience in Excel and macros and completed several similar automation projects. I would request you to visit my profile to know more about my past experience and work quality. Thanks. Look forward to working with you.
$50 USD за 1 день
4,9 (182 відгуки(-ів))
7,2
7,2
Аватарка користувача
Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. I reviewed the attached files, and everything is clear to me. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chrys
$70 USD за 1 день
4,9 (73 відгуки(-ів))
6,8
6,8
Аватарка користувача
HI Sir I will develop a macro to parse the given row Regards
$80 USD за 3 дні(-в)
5,0 (436 відгуки(-ів))
6,7
6,7
Аватарка користувача
Hey, Do you have pen and paper? Take it that and give 100 marks for me out of others. Because, i have the exact taste of you. If not, hire me. Because, I don't have pen and paper as same like you. Thank you.
$100 USD за 4 дні(-в)
5,0 (150 відгуки(-ів))
6,6
6,6
Аватарка користувача
I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you..
$50 USD за 1 день
5,0 (49 відгуки(-ів))
6,5
6,5
Аватарка користувача
Hello I'm experienced Python developer and I'm interested with your task. I have extensive expertise in processing Excel spreadsheets with python code. I'm able to create the program that will parse the specified field. Let's discuss it in detail. Regards, Alex.
$200 USD за 1 день
5,0 (24 відгуки(-ів))
5,9
5,9

Про клієнта

Прапор UNITED STATES
philadelphia, United States
4,9
28
Спосіб оплати верифіковано
На сайті з січ. 20, 2006

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.