Formula or Macro to sort data from data.

[LukeFerry]

Hi I am looking to try and convert data that have been collected off some survey forms. The data appears like this below. I am wanting to create lists like shown further down. Is there a formula that i can use to copy down? I am looking at trying to convert around 200 rows into this list shown at the bottom of the page.

Could you please assist me

Regards,

Luke Ferry

Sample Data Table:

ORGINAL DATA

NAME

SURNAME

AGE

PHOTO

NAME

SURNAME

AGE

PHOTO

NAME

SURNAME

AGE

PHOTO

NAME

SURNAME

AGE

PHOTO

LUKE

UNDERARMOR

34

YES

JENNA

SPLINT

32

NO

JOSH

HARDWOOD

12

NO

JACK

FLAT

45

YES

MINI

BIGGS

33

YES

DAMIEN

FORD

22

NO

GAVIN

CRESWELL

14

NO

DAVE

BLACK

12

NO

SKYLAR

BLUE

25

YES

DANE

SMORES

67

YES

SHANE

LITTLE

45

YES

APPLE

EYE

26

YES

AIM

NAME

SURNAME

AGE

PHOTO

LUKE

UNDERARMOR

34

YES

JENNA

SPLINT

32

NO

JOSH

HARDWOOD

12

NO

JACK

FLAT

45

YES

MINI

BIGGS

33

YES

DAMIEN

FORD

22

NO

GAVIN

CRESWELL

14

NO

DAVE

BLACK

12

NO

SKYLAR

BLUE

25

YES

DANE

SMORES

67

YES

SHANE

LITTLE

45

YES

APPLE

EYE

26

YES

<tbody>
</tbody>