Hacker News new | ask | show | jobs
by adepressedthrow 1416 days ago
That's exactly what I did. Now separate out some columns and perform some additional transformation on that FILTERed data. Can you do it without repeating yourself (duplicating the FILTER statement, or any of the other transformations you need to do, besides just filling down a column). Can you perform these transformations only on the row height of the data, and not have extra rows with broken formulas?

I honestly wouldn't even be surprised if the functionality to do the above does exist, but for all of my searching I couldn't find it.

1 comments

This is something I faced in both Excel and GSheets (when working with formulae only). That is the need to repeat myself occasionally.