Hello everyone,

I am having trouble with something that I feel may have a very obvious solution. I have a table such as:

Test1 85 90
Test2 72 82
Test3 45 47

Which is basically 85 out of 90, 72 out of 82, etc and I want to use some sort of excel formula to format this to a layout where:

Test1 (cell:A1)
85(A2) 90(B2)

Test2 (C1)
72(C2) 82(D2)

Test3 (E1)
45(E2) 47(F2)

Sorry for the awkward way I explained but my brain is getting fried and this is the easiest explanation I came up with.

Thanks to anyone who understands why I'm trying to get at and for any help!

-Sarah