Find Jobs
Hire Freelancers

Reformat/normalize an Excel stocklist

$30-250 USD

Completed
Posted almost 8 years ago

$30-250 USD

Paid on delivery
Hi there! I have a stocklist of +120 000 rows. Each product has its own row. Each row contains: [login to view URL]|Art ID|Description|Segment|Category|Pcs|Pallet|Price|Total price I want to reformat this excel list so that instead of each product has one row I would like each Pallet to have one row. PALLET|Description|Segment|Total Value So all products that are on that pallet should be included in the description and the total value of all those products should also be specified. See the provided textfile for an example. Best Regards, Stefan
Project ID: 10426245

About the project

13 proposals
Remote project
Active 8 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
Googd morning, I ll code a VBA macro to group the products by Pallet and calculate the total amount. So we will get a row per pallet. It will be done today. I m ready to start. So can you please send me the file. Thanks
$88 USD in 3 days
4.9 (286 reviews)
7.7
7.7
13 freelancers are bidding on average $135 USD for this job
User Avatar
Hi, my name is Sevinc. I read your "Reformat/normalize an Excel stocklist" project descriptions carefully before bidding. I checked the attached txt file as well... I got what you need and ready to go ahead as soon as we can clarify further project details. 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.
$130 USD in 3 days
4.9 (297 reviews)
7.9
7.9
User Avatar
hello, i can do this project. i have experience in doing so. will do as desired. will deliver on time. will do with highest quality. you can see my review for your reference. regards
$100 USD in 3 days
4.9 (104 reviews)
6.2
6.2
User Avatar
Hi, Can you send me excel file, I am ready to start working right now and assure you desired results quickly and accurately. Waiting for your reply. Regards, Muzamil
$277 USD in 3 days
5.0 (4 reviews)
2.9
2.9
User Avatar
Hello Sir I have seen your project and can easily create an Excel file and make the necessary changes of rows as mentioned by you. I have worked on similar projects you are looking for, and I am sure I can meet your expectations. I am expert in this field. Hope I included all information you are looking for in a freelancer. I can achieve the results that you are asking for. Awaiting your reply, Thanks.
$30 USD in 4 days
5.0 (2 reviews)
2.0
2.0
User Avatar
Hello. My name is Rajesh. I am Microsoft Certified Trainer and also expert in wordpress, php. So, if you want to get the work done more accurately please contact me.
$87 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hy interested in doing your job as am good in data entry. i viewed your given file. i understand what to do. will do this on time. if you feel suitable then assign me
$222 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, My name is Maaz Imran and Im an electrical engineering student with major interest in Computer Vision and Machine Learning. I think I am a very good fit for this task as I have just recently completed another similar excel sheet reformatting, using probability distribution fitting and confidence interval calculation : https://www.freelancer.com/projects/Mathematics/Probability-confidence-grading/ This task involves less hassle and I should be able to complete it within a few hours. Looking forward to hearing from you. Regards, Maaz Imran
$66 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am actively involved in market research, telemarketing, direct sales and technical advisory. I am trainable, self-motivated, result-oriented, team player who handle challenges and work under pressure with minimal supervision. I work comfortable in a multicultural environment with good interpersonal skills. My enthusiastic involvement in many activities outside of the working circle has served me well in nurturing my leadership and communication skills which are essential to succeed in the working world. Your kind and positive response will highly be appreciated and reciprocated with adequate commitment, diligence, reliability and a high degree of integrity. I am interested in doing your great job perfectly.
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWEDEN
Bromma, Sweden
5.0
95
Payment method verified
Member since Aug 30, 2010

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.