So, I'm working on a project in Google Sheets that has me creating a symmetric matrix. I've filled one half of it with the correct values, but I'm not happy with the idea that I have to reinput the same data (or cell references) by hand on the other half.
Is there either an option that will do this for me, or a way to otherwise automate the process? I know about paste transpose, but that gives me the same chart, with the empty half below rather than above, and still no way to get the data into the other half. I suppose I'd also accept a way to combine the two sheets, putting the filled values from one into the empty values from the other, or some sort of "transparent" paste where an empty cell in the pasted range doesn't overwrite the data in the cell it's pasted over.
Screenshot of what is filled in so far: