Find Jobs
Hire Freelancers

NO AUTO BIDS: Google Sheets Data Split using formulas. 7 cells, 3 sections split into 21 columns

$10-30 USD

Completed
Posted about 2 months ago

$10-30 USD

Paid on delivery
I have a google sheet where we put 3 paragraphs of data into 1 cell. I have included an image showing the "reasoning" columns (D-J) which needs to be split into 3 sets of data (K-Q), (R-X) & (Y-AE) I already did the first row manually. For this job you need to split the cells into the target rows and also have a QA step and recombines the split data into a "QA Check" concatenation. Then a final check to verify that the original = QA check. This is to verify no data was lost. Here is a read only link to the sheet: https://docs.google.com/spreadsheets/d/1TiyKKNjrEHeCrNySmmiD9xWQXTjd1OAh-8fUluSLRR0/edit#gid=420694380 rows 4-509 need to be done. Only work with the new fields, do not edit the original data This needs to be done with formulas, not manually. For an excel/google sheet expert this should be a 1 hour job. To show you have read this posting and have attention to detail, put your favor color as the absolute first word in your bid in ALL CAPS. If you don't do this, your bid will be deleted. Good luck
Project ID: 37919696

About the project

12 proposals
Remote project
Active 2 mos 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
BLUE..I am an expert in excel and can make the project for you immediately within few minutes..thanks..looking forward to work with you
$30 USD in 1 day
5.0 (434 reviews)
6.8
6.8
12 freelancers are bidding on average $22 USD for this job
User Avatar
Hi, this is very simple and i've done it many times before. If you are interested, feel free to message me so i can ask few follow up questions. I've looked at the attached png file and yes this is definitely possible. I am available right now. Thanks, Milan
$15 USD in 1 day
5.0 (779 reviews)
7.5
7.5
User Avatar
ALL CAPS As someone with over 3 years of experience in using Google Sheets and Excel, I have developed an expertise in data manipulation and automation that is crucial for the task at hand. Using formulae to split the given paragraphs and ensuring that no data is lost while manipulating them is a task that I can achieve quite flawlessly. My past experiences bear testimony to my ability to not just use formulae but also conduct meticulous QA checks to ensure accuracy. I understand the project requirements vividly - from splitting the 7 cells into 21 more columns, creating a QA Check concatenation, to verifying if the original = QA check. Having already referred to your sheet, I am confident that I can deliver results as accurate as your first row. Your task requires an analytical mind and an attention to microscopic details; characteristics which I possess in abundance. Moreover, I'm very intrigued by your method of evaluating the bidders' quality by asking them to put their favorite color in ALL CAPS as the first word - I believe it's a great way to filter out genuine bids. Hence, keeping things consistent, here's my pitch: BLUE! With a proven track record in project completion and delivering quality work within stipulated timelines, I feel confident in assuring you that this job, billed at around an hour of work for a skilled professional like me, will be done swiftly and accurately!
$30 USD in 1 day
5.0 (40 reviews)
4.8
4.8
User Avatar
Dear Donato D., BLUE https://www.freelancer.com/u/sajidjasi Hope this message finds you well. As a seasoned expert in Microsoft Excel and Google sheets, I bring a comprehensive set of skills and experience. My proficiency includes: Power Query Advanced Formulas and Functions Data Visualization; and VBA Data Analysis Data Validation and Cleaning Pivot Tables and Pivot Charts My dedication to delivering high-quality results, attention to detail, and commitment to meeting deadlines have consistently earned me the trust of clients. I pride myself on my problem-solving abilities and adaptability to various industries and business needs. You can count on me to provide effective solutions and support for your project titled "NO AUTO BIDS: Google Sheets Data Split using formulas. 7 cells, 3 sections split into 21 columns". I am reviewing the attached file and let we discuss... Regard, Sajid Hussain
$25 USD in 1 day
4.5 (21 reviews)
4.4
4.4
User Avatar
Hey Donato, I have carefully read the project description and reviewed the Google Sheets document provided. To split the 3 paragraphs of data in each cell into 3 sets of data across 21 columns as specified, I will use formulas to automate the process for rows 4-509. My approach will involve creating formulas to split the data into the target rows (K-Q, R-X, Y-AE) and then conducting a QA check to ensure data integrity. I will then concatenate the split data for the QA check and verify it against the original data to confirm no information loss. By following this method, I will ensure accurate data splitting and verification while maintaining the integrity of the original information. I am confident that my expertise in Excel and Google Sheets will allow me to complete this task efficiently. Please initiate the chat to discuss further details. Best regards.
$15 USD in 1 day
5.0 (1 review)
1.4
1.4
User Avatar
i am already work with this skill as a job so i am best fit your project because i know how to do this work perfectly. #dataentry #excel #editing #pdf and i am also a DATA OPERATOR.
$10 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As a seasoned Excel expert with a keen eye for detail, I couldn't help but notice the precision and efficiency required for your project. I have spent countless hours working on similar data splitting and recombination tasks not just manually but, importantly, using formulas. As proof of my skills, I invite you to take a look at my One Hour Task Club badges on my profile, highlighting successfully completed projects despite the tight deadline. Trust me with any data entry or Google sheet task. Additionally, my expertise in Google Sheets and familiarity with formulas will ensure that your project receives prompt attention in line with your request. I'll successfully split the three paragraphs in each cell into the three target sets and then conduct a thorough quality assurance check by recombining them into "QA Check" concatenation - no data lost! My vast experience in handling such tasks makes me to be efficient even in large datasets (such as rows 4-509) without compromising the accuracy and integrity of any information. Landing this gig as an Excel and Google Sheets extraordinaire will not only benefit you tremendously but also be an opportunity for you to experience highly professional work delivered within a short time frame. Remember, when you say “done” it means done well. Thank you for your consideration and all the best with your hiring process.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, there i have 5 years' of experience in Data Entry Operator, also i skilled in typing work my typing speed is 52 wpm with 98% accuracy and i am looking project for give a best service online. Thankyou.
$30 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Oconomowoc, United States
4.9
297
Payment method verified
Member since Feb 16, 2007

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.