This is my first foray into using a forum for my specific question, so, please, let me know what additional information might be necessary. I am providing some information below; yet, if it is better in a different format, please, let me know.
I am attempting to use a query in Google Sheets to dynamically clean some data that is populated by another source rather than cleaning each time the data are updated.
I would like to have rows with only those ID occurring twice (i.e., once with a Pretest and once with a Posttest). Further, I need a column with the Value of the Pretest and a column with a Value of the Posttest; following, I would love the query to populate an additional column with the percent change pre-to-posttest.
I am flummoxed and cannot create this dynamic formula.
Please, let me know if there is anything more needed to help with this request.
|ID||Pretest Value||Posttest Value||% Change|