Excel reorder data

$30-250 USD

已完成

已发布

大约 6 年前

$30-250 USD

货到付款

I have a large Excel spreadsheet (280K rows) with 1 column containing a semi-colon delimited list with a string of products followed by qty in brackets for each customer. For example: row 1: "Product C (1); Product A (9); Product F (4);" row 2: "Product B (12);" row 3: "Product G (1); Product D (2); Product E (1); Product B (12);" Some customers have 1 product and some have all products and all products are unordered. We need this column broken into unique columns for each product in alphabetical order without changing the row order. So in the above example, the output we require would be: row 1: Product A (1) empty Product C (1) empty empty Product F (4) empty row 2: empty Product B (12) empty empty empty empty empty row 3: empty Product B (12) empty Product D (2) Product E (1) empty Product G (1) See attached example of format of data and the required output in seperate tab.

Data Processing

Excel

项目 ID: 16354642

关于此项目

23提案

远程项目

活跃6 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@ksriniravi

Greetings! I have reviewed the attachment and understand what needs to be done. I can write a macro to automate the process. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 20 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Weekend! Srinivasan Krishnamoorthi

$50 USD 在1天之内

5.0

(191条评论)

6.8

23威客以平均价$89 USD来参与此工作竞价

@KulfiSoftwares

I love excel automation, and can quickly and accurately split the data by semicolon and have a blank column between each Product, like requested. ZERO ERROR GUARANTEED!! Please read my 300+ reviews. I am here to impress you with my work.

$100 USD 在3天之内

4.9

(287条评论)

7.5

@Kalpanasekhar

Hi There, I understood your requirement. My question is how many products will be there maximum per customer? I can do it this job. Please share the excel file. Thanks and awaiting your reply. Kal

$111 USD 在1天之内

4.9

(139条评论)

7.6

@P0L

Hello, I’m an Excel/VBA 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 在1天之内

4.9

(345条评论)

7.4

@datakillers

I am ALISON certified for Microsoft Office specially Excel and Access Database. Data Entry and Processing is my passion with years of experiences. I am very hard working and know the value of time so, always deliver work on time. My motive is to make my employer happy with quality of service.

$30 USD 在0天之内

4.9

(227条评论)

7.1

@ReliableMate

Understood, Need to arrange the products into columns as shown in the example. We are a team of 7 members and we can get it done with complete attention to details.

$90 USD 在3天之内

4.9

(116条评论)

6.6

@expertatwork

A proposal has not yet been provided

$30 USD 在1天之内

4.8

(153条评论)

5.8

@gr8tech

Hello there, I am able to split your column data and provide the results quickly. I am available to start the work and look forward to hearing from you. I have experience working with Excel/Formulas/VBA for data processing, analysis and automation of tasks. Moosa

$50 USD 在1天之内

4.9

(41条评论)

5.4

@rinsadsl

Hi there What you are asking for could be achieved using a program. If your excel sheet is quite large we can use a database for the job. If it is small enough we can use in memory arrays for it. Anyhow I am quite confident that I can do the job. Looking forward to working with you. Thanks Rinsad

$189 USD 在3天之内

4.9

(32条评论)

5.5

@AmrBalshy

Dear Sir, It would be a pleasure for me if you accept my bid to work together. I can handle this task professionally with my experience in excel. Feel free to ask any questions. Best regards.

$55 USD 在3天之内

5.0

(15条评论)

4.4

@nurnga1218

Hi, I did some project like yours. I'll make a button (Macro VBA function) to do it... so you can re use again for another workbook with same cases. I'm waiting your reply, Thanks

$30 USD 在0天之内

4.9

(38条评论)

4.4

@startechoffshore

Hi there! Your project seems interesting to us and we believe we would be a perfect match for your requirement. Our team consists of highly qualified professionals who are dedicated to 0 error, 100% on-time and top notch work. We would love to do a free sample for you so that it is easier for you to decide the right freelancer. Thank you!

$111 USD 在3天之内

4.9

(30条评论)

4.0

@GroupRH

Hi Dear ! I am seeing your project and i thought i am the most specific and suitable person for it. Your Project is simply related to my interest. I have the best reviews in this skill. I will enter your data on (Excel 2013) Your data will be Accurate & Well Mannered thats my guarantee. I will complete your project on given time surely. Your satisfaction will be my first priority. I will also discuss about the progress of my work on your project at daily basis. If you want my services then message me and share more details about your project. Thank you!

$88 USD 在1天之内

4.9

(20条评论)

4.0

@lherreraz

HI there! I perfectly understood what you need, so I have a large experience working with advanced Excel and Macros using VB, the most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.

$55 USD 在2天之内

5.0

(15条评论)

3.8

@yh2013

I worked with many projects based on Excel that included macro, most of them for web scraping, dashboard, forms. I have the required expertise for your project. Check my portfolio.

$77 USD 在3天之内

4.8

(11条评论)

3.7

@huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now

$50 USD 在3天之内