A
Alvey
I've got a workbook with two sheets. One sheet contains
all the fields and data I need except it only lists one
status report per event, but some events have multiple
status reports. The extra reports are listed on the
second sheet and each status report is linked by a key
(number) field (one-to-many relationship, but since it's a
spreadsheet there isn't an actual relationship beyond
organization).
What I need is to get one sheet that has a single entry
for each status report. Say the first event had three
status reports, I need all the information from each field
on three seperate lines with the three different status
reports at the end. How can I do this in excel?
all the fields and data I need except it only lists one
status report per event, but some events have multiple
status reports. The extra reports are listed on the
second sheet and each status report is linked by a key
(number) field (one-to-many relationship, but since it's a
spreadsheet there isn't an actual relationship beyond
organization).
What I need is to get one sheet that has a single entry
for each status report. Say the first event had three
status reports, I need all the information from each field
on three seperate lines with the three different status
reports at the end. How can I do this in excel?