New hobby: leading with "absolutely normal pile of spreadsheet functions that was not written by a furry with three mental illnesses" and then pasting a screenshot of whatever abomination I just finished LEGOing together.

*tiny furry cheeps*
New hobby: leading with "absolutely normal pile of spreadsheet functions that was not written by a furry with three mental illnesses" and then pasting a screenshot of whatever abomination I just finished LEGOing together.
If your spreadsheet isn't an unholy amalgam of awkward QUERY and CONCAT functions with some extra obscure nonsense for flavour what's even the point.
Me: this is conceptually a very simple thing I want to accomplish!
At least one search engine visit later: a JOIN() (JOIN: for when you want CONCAT... but Worse!โข) filled with not just MOD() (oh god I know what MOD is now. why is that one named that) but IF()s to fix the MOD() outputs because I am too aboard the struggle bus to actually write a math equation. AND I EVEN WORKED A TRUNC() IN THERE, which is how you confirm I am NOT DOING OKAY!
Thinking about all the times I've had to combine INDIRECT with ROW and COLUMN in some ridiculous fashion instead of just using an actual cell reference because gosh forbid anything be simple in this spreadsheet.