Quick fix - Automatically Reformat google sheet data into correct columns of another sheet within the book
Budget: £10 – £20 GBP
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.
https://docs.google.com/spreadsheets/d/1AlYRdy9g0jnxki3qHuUHF-xeaHKHdSK1Vm9EPrPaGtU/edit?usp=sharing
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
https://docs.google.com/spreadsheets/d/15fEp2Lp6_GooApObTJze0_xfNi3rphxxOc3DqU5pWtw/edit?usp=sharing
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.
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.
https://docs.google.com/spreadsheets/d/1AlYRdy9g0jnxki3qHuUHF-xeaHKHdSK1Vm9EPrPaGtU/edit?usp=sharing
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
https://docs.google.com/spreadsheets/d/15fEp2Lp6_GooApObTJze0_xfNi3rphxxOc3DqU5pWtw/edit?usp=sharing
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.