i built a spreadsheet a while back to help manage my fantasy hockey league....

https://docs.google.com/spreadsheets...gid=1014237120

i'd like to update to the new google sheets, but they got rid of the 'continue' function. i do not understand why they would do this and i have no idea how to fix the above to make it work again like it does in the old version.

all continue functions were entered by hand b/c i couldn't get the arrayformula method to give me the result i desired. 'sheet2' is what it is supposed to look like. if i could just get the 1st team to import correctly....

thank you so much for your help!