Short term: I’m trying to automate transcribing a list from:
A
123
234
B
456
567
789
C
345
Into an array/table
123, A
234, A
456, B
567, B
789, B
345, C
Long term answer I’m looking for: where’s a lemmy community I can ask questions like this (like about using formulas in Librecalc/Onlyoffice suite/maybe VBA with them too) in the future?
Or, if not yet established on lemmy, recommended librecalc/Onlyoffice forums?
Thank you for your time.
No worries! I just like to be absolutely sure, because I’ve seen a lot of fringe cases in excel that really make you think hard about how you’re going to lay everything out. I just wanted to be sure before I worked on it. I love Excel, though, and wouldn’t have minded doing it over lol.
The formulas in my other reply should absolutely work. Let me know if you need help with that!
Also, I’d definitely be interested in a “Libre/OpenOffice help” group. I think it’s fun finding creative and clean ways to solve things that seem difficult.