Re:Excel never dies (2021)
by LasEspuelas on Thursday August 04, 2022 @07:42PM
(#32349720)
This is something I faced in both Excel and GSheets (when working with formulae only). That is the need to repeat myself occasionally.
I will ramble a bit, but for complex data transforms, you can use PowerQuery instead of formulas. For semi-serious programmers like myself, I started doing C# add-ins to Excel using Excel-Dna. There’s also Query Storm. :)
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.