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
    2
    ·
    10 months ago

    To clarify the first, yes to your example, I think so. I’m trying to optimize my scanning process, so, optimally, yes, I would only record all A numeric values in one go, and not come back to them again for the rest of the list. Good question; I never thought about this as a complication. So, I have shelves among shelves with a strict naming convention and containers with a different naming convention. I’m figuring out how to help me and my family be lazier and just capture the shelf name, then all the stuff there, then move on to the next place.

    To clarify the second concern, yeah, I meant to make the comma denote two separate cells. I’m not sure how to make a table on lemmy through the Boost app.

    • Donovar@lemmy.world
      link
      fedilink
      arrow-up
      2
      ·
      edit-2
      10 months ago

      Actually, shoot… After rereading your reply, I might have taken your example data too literally. Are the alpha values truly always alpha and your numeric values always numeric? Otherwise it won’t work, and I’ll have to find another solution.

    • Donovar@lemmy.world
      link
      fedilink
      arrow-up
      1
      ·
      10 months ago

      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.