Create Macro to parse Spreadsheet

$10-30 USD

Imekamilika

Imechapishwa

about 6 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa

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

Kitambulisho cha mradi: 16709249

Kuhusu mradi

11 mapendekezo

Mradi wa mbali

Inatumika 6 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@zebracaro

Hello. the budget down. Please contact me ! .

$50 USD ndani ya siku 1

4.9

(108 hakiki)

6.9

11 wafanyakazi huru wana zabuni kwa wastani $34 USD kwa kazi hii

@sohandas

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 ndani ya siku 1

5.0

(271 hakiki)

7.1

@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.

$50 USD ndani ya siku 2

4.9

(306 hakiki)

7.3

@VladimirLilenko

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 ndani ya siku 0

5.0

(58 hakiki)

5.8

@kahilH

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

$40 USD ndani ya siku 1

4.7

(33 hakiki)

5.1

@Gajacrafty

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 ndani ya siku 0

5.0

(22 hakiki)

3.4

@acabeguin

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 ndani ya siku 1