Hi Tom, yes this really clarifies what I was trying to convey, thank you! I do have a version of my data that looks like this, however, I'm still at a loss as to how I would output a column that subtracts time 1 results from time 2 only when treatments X and Y are administered and then find the differences between those two in the long format. Down the line when I conduct data analysis comparing this "result difference" between the XY/YX groups, wouldn't the wide format that has one "result difference" per subject be easier to work with?
... View more