Formula Help Needed (Probably a really simple solution)

[Fornicis]

Hi all,

I’m currently making a spreadsheet for a game I am making, currently I’m trying to find a quick way to import all of my items and level stat curves into one sheet to make it easier to reference them, currently they are set out in a different way to how I want to access them now, I’ve attached screenshots of what I mean. (On the left are the Column Ref and on the top are the current cells Row Ref, on the bottom are what I want them to be)

Basically I am looking for a way of copying the formulas in shown in the range, keep the columns the same but increase the row amounts by only 1, currently they’re automatically increasing by 8 (The range of rows selected ofc), I’m sure theres a way of doing this but I’ve got spreadsheet block it seems.

https://imgur.com/a/whS9c4Z

[fpy]

→ Ask/Guide - How to use the Ask site - The Document Foundation Wiki

---

[joshua4]

Sorry to presume, but it seems like “you might not really want to do what you are doing,” anyway. I get the idea that you want to do some sort of difference operation on the data set. The layout in the pic seems non-intuitive to me for that. Have you considered pasting all the data into a spreadsheet as-is (if not there somewhere already) then using, say, a combination of INDIRECT(ADDRESS(…)) to do what you want, perhaps even with an INDEX(MATCH(…)) combination to select HP, MP, etc., on a separate analysis sheet? If you haven’t, you might look into it. Otherwise, yes, take @fpy’s hint and upload an example file, and expand on what you want mechanically vs what you are doing semantically.