I'm given this chart in excel thats 10x10 cells in size.
I'm wondering if i should create the table as per in the excel file, or should i create the table as in header, side, and value columns instead?
I've included an image to illustrate it better.
The top left is an example of the given chart in excel (scaled down of course).
Bottom right is what I could think of so I could reference the values by checking header and side = a certain values.
The header D is just to show that the inputs can jumble around as long as the rows are fixed etc, header (D) = side (2) = value (i).
but i could reference the values in the original format too. by referencing a col to the side value.
so which one goes?