Find Jobs
Hire Freelancers

Conversion Spreadsheet (Combine Training Records)

$30-250 USD

Completed
Posted over 1 year ago

$30-250 USD

Paid on delivery
Combine rows in Excel: Excel file has approximately 15,000 rows that contain student records for 6,400 students. There are multiple records (rows) for each student. Each row contains a unique student # that is the same for each record/row for that student. (COLM A= "ID") Most students only have 4-5 rows. The rest have from 6 - 54 rows. Each row has a column that has info that has been merged from four other columns in that row. COLM's M& N show how this was done manually. Column O is the desired result (pasted as values) with one row per student illustrated rows 3, 7, 10, 29, 37. Note 1: In the sample file, the date sort is not correct. See Note in first row. Should sort by ID and by date newest to oldest. Note 2: This file will be imported into a CRM for History info in a text field. Format must include the equivilent of line breaks and "wrap" type view Client was planning on having staff do this manually but wanted to offer them the option to have this done for them. The attached file is partial and should provide a good spec for you. Thanks. Roger
Project ID: 34602480

About the project

39 proposals
Remote project
Active 2 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
$0 USD in 2 days
5.0 (593 reviews)
8.6
8.6
39 freelancers are bidding on average $141 USD for this job
User Avatar
"""""""""""""""""""COMBINE TRAINING RECORDS""""""""""""""""""" "Sir, I am Excel, Excel vba macro Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working here from the last 1.5 year and I have 224+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar
$98 USD in 1 day
4.9 (259 reviews)
7.3
7.3
User Avatar
Hi, I'm an Advanced Level Excel/Google sheet Expert and will do it. Please send me a message so we can discuss further. Thank You
$100 USD in 1 day
4.9 (132 reviews)
6.0
6.0
User Avatar
Hello Sir , Iam excel expert level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need this finished? I understand how annoying it is and can get this fixed for you quickly! Please see the sample I fixed. I look forward to working on this project with you. Regards ILYAS
$95 USD in 1 day
4.9 (209 reviews)
6.2
6.2
User Avatar
Excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
$140 USD in 2 days
4.8 (151 reviews)
5.8
5.8
User Avatar
Hi Roger, Your Spreadsheet Specialist is here Graduated from London; United Kingdom in Investment & Finance; Risk Management. I have done various VLOOKUPS, Macros, Data Analysis, Sorting of data, VBA, Hyperlinks and etc. I have handled various excel projects such as Financial Modeling, Risk Assessment, Balance sheet, Income Statements, Data Sorting and etc. I will be able to complete your task as per your requirement and understandings Feel free to inbox for more details and budget Regards, S.A
$40 USD in 2 days
5.0 (3 reviews)
3.3
3.3
User Avatar
yes i will do your project come in inbox if any mistake occur after the project is done then you easily contact with me first of all nothing wrong is happened everything i done well.
$80 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am an expert in Excel and VBA. I have done several projects in which I have done any task using programming in VBA. I can do it quickly and will provide you with quality and fast work. Can we discuss all your needs clear? Best regards.
$100 USD in 7 days
5.0 (1 review)
0.0
0.0
User Avatar
Am asad, I have been working on these skills for five year If you want to benefit from my work, contact me and I will make you 100% to your standards until you are completely satisfied with it. Regards
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Ocala, United States
5.0
1
Payment method verified
Member since Aug 9, 2021

Client Verification

Other jobs from this client

Develop API
$250-750 USD
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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.