How to data from four colums, but list two of them under each other

In F2, copied across and down:

=IFERROR(INDEX(A$2:A$3,MATCH(0,INDEX(--(COUNTIF(F$1:F1,A$2:A$3)=COUNTA($C$1:$D$1)),0),0)),"")

In G2, copied down:

=IFERROR(INDEX($C$2:$D$3,1+MOD((ROWS(H$2:H2)-1),COUNTA($C$1:$D$1)),1+INT((ROWS(H$2:H2)-1)/COUNTA($C$1:$D$1))),"")

in Finland, you may need ; instead of ,

Duhhh!! I got my MODs and my INTs the wrong way round!! AND I've already had my morning coffee.

=IFERROR(INDEX($C$2:$D$3,1+INT((ROWS(H$2:H2)-1)/COUNTA($C$1:$D$1)),1+MOD((ROWS(H$2:H2)-1),COUNTA($C$1:$D$1))),"")

Single non array formula in F2 then drag down and accross

Please Login or Register  to view this content.

You're welcome. But do also take a look at the other one at Post 5. It's very neat!! Both work by using complicated looking formulae to return column and row numbers... If you need help understanding something, just ask. However, formulas/evaluate formula is a good place to start.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.