Completed

Quick fix - Automatically Reformat google sheet data into correct columns of another sheet within the book

Job Description:

Hello.

I have 125 Google sheets of Multiple-Choice Question Data. These are all formatted identically and an asterisk is used to identify the correct answer.

An example of the first sheet of data can be seen here.

[login to view URL]

To import all of these quizzes into my website I need to reformat each sheet automatically to match the new template. The biggest change here is that an asterisk is no longer used to identify the correct answer and instead it is a numerical value of 1-4 which indicates if the correct answer was A,B,C, or D.

Ideally, I would like to be able to copy the original sheet of data into a book, run a script and end up with the data formatted correctly for export. An example of the new template can be seen here

[login to view URL]

I would be interested in speaking with anybody who can automate this process but also anybody who would be willing to convert all forms to the new format and upload to my website.

i look forward to hearing from you.

Skills: Excel, Google Sheets, Google Spreadsheets, Spreadsheets

About the Client:
( 19 reviews ) Hove, United Kingdom

Project ID: #35415583

Awarded to:

stanclark121

Hi, there is a formulaic method I can use to reformat all of these into the 1-4 system you require. Please let me know if you are interested, and I can get this done for you today.

£15 GBP in 1 day
(3 Reviews)
1.4

12 freelancers are bidding on average £19 for this job

b0b90

Hi I am an expert excel developer with over 4 years of development experience. I can do this task manually or create a automatic way as well. Let's discuss it over chat Regards

£30 GBP in 2 days
(3 Reviews)
2.4
benson2augustine

Hi friend, iam a software developer by profession, iam working as a full stack developer, we can do it using python xlrd and pandas dataframe and some Google APIs , if u r interested let's discuss

£15 GBP in 2 days
(1 Review)
0.5
JerichoMercado

Hi there. Looked at your job post and I can do the task you've mentioned.:) I can start immediately. HIRE ME *Wink* Looking forward to work with you. Best, Jericho

£15 GBP in 7 days
(0 Reviews)
0.0
devyadavbudharra

Hi, there is a formulaic method I can use to reformat all of these into the 1-4 system you require. Please let me know if you are interested, and I can get this done for you today.

£15 GBP in 7 days
(0 Reviews)
0.0
SolankiPrachi213

Hey prachi here I can correct the sheet with in the time limit I can convert all the sheets and submit to you directly

£15 GBP in 7 days
(0 Reviews)
0.0
vinodjagarlamudi

I have 3years of working experience with google workspace. Developed several macros for copying data from one spread to another with different requirements. I can automate your task in 2days.

£15 GBP in 7 days
(0 Reviews)
0.0
Jeanphilippe38

Hi, I can definitely do this with a macro in excel. Even apply it to multiple files at once. We will have to convert it back to google sheets then. Just show interest with a message and I will get to work and show yo More

£10 GBP in 1 day
(0 Reviews)
0.0
omarrayhan28

Hello sir, I'm interested to-take your job & I'm highly confident that I'll be able to do your job perfectly as per your requirements. Although I'm an entry-level freelancer for this platform, I have a good experience More

£15 GBP in 7 days
(0 Reviews)
0.0