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.
Have you tried asking a LLM? I find them useful for queries like this.
Thanks for checking. I asked ChatGPT3.5 to make a solution with excel since I have limited access to it at work. CG came up with making my data a table with Power Query & using a Fill tool, but Fill>Down isn’t doing what CG is saying it’s supposed to do.
I hope I could do this at home though because I only have Onlyoffice & Libreoffice, & excel in the browser is so limited.