02-15-2018 07:02 AM
I have two tables as shown in the attachment. I want to create the result table, which is shown at the bottom of the attachment:
Can someone give me a hand please? I really appreciate everyone who have been helping me so far.
02-15-2018 08:55 AM
02-15-2018 09:06 AM
I am not understanding what you want, so can you explain in more detail please? How do you want to make Table 2 from Table 1? The step after that is just the DIAG function, as the 2nd "22" in the result matrix is a typo, right?
02-15-2018 09:18 AM
Ah, Sorry Ian. My bad. You are right.
I guess i'm not able to think straight now :-)
Diag is the option. i was wandering how to put that in the shape of table 1.