Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now
1 of 5

How to split data across multiple rows when submitting from Google Form

I'm relatively new to the stack exchange community so I apologies if referencing a previous question in a new question is frowned upon but I have a problem similar to the one mentioned in this question Forms Data Manipulation In Google Sheets accept instead of having 5 header cells and 6 data cells per row I have 1 header cell and about 20 data rows. I am however having immense trouble editing the formulas that are mentioned in the above question. I copy and paste them into the formula bar and when ever I try edit anything other than cell reference in the offset function my changes and rejected and reverted back to the original formula. I might be editing the row part of the formula because I don't quite think I understand how it works so any guidance you can give me would be greatly appreciated. Here is a link to my first attempt. https://docs.google.com/spreadsheets/d/1D-BORzV0-6nLBeQBDY_XOxolr5Dp-ohxax3ikzyxsrM/edit?usp=sharing.

Thanks,

word4q