Converting Office365 Sort Function Formula into Office 2013 or 2007

[aaaaa34]

along A column, i have club names and its forward player names following row below.
I want to sort A->Z for A column in terms of club names and relevant player row below as it's shown in E column. in the image I attached.
in office 365, we can use this formula to perform it.
=TOCOL(SORT(WRAPROWS(A2:A11,2)))

How I can make this formula compatible with office 2007 or 2013? Or is there any logical method else to solve it?
Thank you.

[Glenn Kennedy]

1. Named range "Sort"
=MOD(AGGREGATE(15,6,COUNTIF(Sayfa1!$A$2:$A$11,"<"&Sayfa1!$A$2:$A$11)*10^6+ROW(Sayfa1!$A$2:$A$11),ROW(Sayfa1!$1:$10)),10^6)

2. Named Range "Team"
=IF(ISEVEN(+Sort),Sort,"")

3. In C2, copied down:
=INDEX(A:A,LARGE(Team,1+INT((ROWS(C$2:C2)-1)/2))+IF(ISODD(ROW()),1,0))

In earlier Excel versions, this will (almost certainly) require CTRL-SHIFT-ENTER... if it works at all!!!

EDIT: It may work in 2013, but will NOT work in 2007. IF (... a bif IF) it does work in 2013, I will convert to a 2007-friendly version.

[aaaaa34]

Hi Mr. Moderator,
Thanks a lot for your reply.
Yup, it did NOT work in 2007, tomorrow in office i will try in 2013 and will let you know it immediately sir.

Thank you.

[TMS]

AGGREGATE is not available in 2007, although ISODD and ISEVEN are, apparently.

[TMS]

It works in Excel 2010, so it should work in Excel 2013.

You can commit with just Enter and drag down. Or you can select all the cells and Array Enter it wit Ctrl-Shift-Enter