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.

    • BlindFrog@lemmy.worldOP
      link
      fedilink
      arrow-up
      7
      ·
      10 months ago

      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.