{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/27ab862fddf64316bff3cf8eacaaa61c\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/27ab862fddf64316bff3cf8eacaaa61c-00001.gif","duration":365.13,"title":"How to Reverse Array Formulas into Normal Formulas 🔄","description":"Hey there! In this Loom, I'm going to show you how to reverse array formulas into normal formulas. This is an advanced technique, but it's really useful if you want to modify something in one specific row, but not all of them. An array formula is a formula in the spreadsheet that puts information in all the subsequent rows beneath. I'll show you how to use the array constraint to stop those zeroes at a certain point and how to get rid of the array formula before and after. By the end of this video, you'll be able to undo an array formula and modify it as you wish. If you have any questions, feel free to send me an email. Enjoy!      LINKS: https://docs.google.com/document/d/18RUw_BFJui3SobCGYlW5E8mvdCzUBS4QWLvOWVlRo6w/edit.    https://docs.google.com/spreadsheets/u/1/d/154BJjulvmOFvhZXWJ1XI9kJMhWZif2mhrfmJqAcsPXM/edit#gid=825024063"}