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.

  • Donovar
    link
    4
    edit-2
    6 months ago

    I usually divide a cell’s value by 1. A value that isn’t numeric will throw an error. Combining that with ISERROR or IFERROR, you can do some pretty powerful stuff.

    • @[email protected]
      link
      fedilink
      36 months ago

      Yeah, there are plenty of ways of doing that, but I was assuming OP’s sheet had other types of cells and that the A’s and 123s were a minimal working example.

      • Donovar
        link
        26 months ago

        And you were correct! I take sample data too literally lol