Find Jobs
Hire Freelancers

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

$10-30 USD

完了済み
投稿日: 約2か月前

$10-30 USD

完了時にお支払い
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
プロジェクト ID: 37919696

プロジェクトについて

12個の提案
リモートプロジェクト
アクティブ 2か月前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
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 1日以内
5.0 (434 レビュー)
6.8
6.8
この仕事に12人のフリーランサーが、平均$22 USDで入札しています
ユーザーアバター
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 1日以内
5.0 (779 レビュー)
7.5
7.5
ユーザーアバター
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 1日以内
5.0 (40 レビュー)
4.8
4.8
ユーザーアバター
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 1日以内
4.5 (21 レビュー)
4.4
4.4
ユーザーアバター
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 1日以内
5.0 (1 レビュー)
1.4
1.4
ユーザーアバター
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 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 7日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
Oconomowoc, United States
4.9
297
お支払い方法確認済み
メンバー登録日:2月 16, 2007

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。