Need to Parse Excel Sheet

$30-250 USD

Închis

Data postării:

circa 6 ani în urmă

$30-250 USD

Plata la predare

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-ul proiectului: 16709157

Despre proiect

43 propuneri

Proiect la distanță

Activ: 6 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

43 freelanceri plasează o ofertă medie de $88 USD pentru proiect

@jaylancer43

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 în 3 zile

5,0

(831 recenzii)

8,9

@seaanddream

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 în 1 zi

4,9

(363 recenzii)

8,3

@schoudhary1553

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 în 3 zile

4,9

(509 recenzii)

8,4

@sohandas

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 în 1 zi

5,0

(376 recenzii)

8,0

@FINGERRPRINT

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 în 1 zi

4,9

(387 recenzii)

8,3

@P0L

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 în 3 zile

5,0

(486 recenzii)

8,0

@ponnarasiBabu

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 în 2 zile

5,0

(448 recenzii)

7,9

@paris2785

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 în 0 zi

4,9

(375 recenzii)

8,1

@mirniyazuddin92

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 în 1 zi

4,9

(440 recenzii)

8,1

@dgled

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 în 3 zile

4,9

(95 recenzii)

7,5

@TonmoyRoy111

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 în 2 zile

4,9

(479 recenzii)

7,4

@zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$70 USD în 2 zile

4,9

(120 recenzii)

7,1

@aubrey03

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 în 2 zile

4,9

(220 recenzii)

7,0

@Attractionnet

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 în 1 zi

5,0

(196 recenzii)

7,0

@aarifakhtar

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 în 1 zi

4,9

(182 recenzii)

7,2

@chriskerpini

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 în 1 zi

4,9

(73 recenzii)

6,8

@rohitagarberg

HI Sir I will develop a macro to parse the given row Regards

$80 USD în 3 zile

5,0

(436 recenzii)

6,7

@paulmd369

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 în 4 zile

5,0

(150 recenzii)

6,6

@axiomswb

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 în 1 zi

5,0

(49 recenzii)

6,5

@exansoft

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 în 1 zi