Grouping data by name as a header with other data below

[nearenough]

hello, sorry for my odd question but im stumped as to what to call this problem.

i have a database of horse race results and at the end of the season i want to make a results book with an index in the back of each horses races and performances

i have 3 columns - Name - Race Number - finishing position for every horse in every race this season

i want the index to show

Name A
Race Number - (finishing position) Race Number - (finishing position) Race Number - (finishing position) etc of each race run that season by that horse.

Name B
Race Number - (finishing position) Race Number - finishing position Race Number - finishing position etc of each race run that season by that horse.

and so on for all horses raced this season. i have done this before in 2009, 2010 and 2011 seasons and i think i used appleworks database to do it. but now i have a new computer and no appleworks. so what now? i have never used base, it all looks daunting and far more complex than i need, can calc do it with a pivot table or something somehow? thank you for reading!

[Villeroy]

file>new>database…
connect to existing database
type: spreadsheet
specify the spreaedsheet document.
save the database document.
Nothing has been converted or copied. All your data are still in the spreadsheet
Click the reports section.
Start the report wizard.

[nearenough]

hi, thank you for that, thats a great help. i can make a results list for each horse now but there’s only one result per line. how do i make it output a report with all results across a line below each horses name please

ie

HORSE NAME
result result result result result

not
HORSE NAME
result
result
result
result

thank you!

[Villeroy]

This might be possible with a true database supporting some function like GROUP_CONCAT…

[Villeroy]

Like this one:
horses.odb (13.6 KB)