J
J. Gutierrez
Hi everyone, let me explain...
I'm working with a large excel file (13,000+ rows) of cancer cases recorded
in the state of Florida. Each time a patient presents with a cancer, that
"case" is recorded as a row on the spreadsheet, along with a UNIQUE patient
ID assigned to that particular individual. If that same person develops
another cancer sometime later, that information appears in a new case/row,
but with the SAME patient ID.
I need to export this file to another program (SPSS v13.0) to do some
advanced statistical analysis. However, the program requires that all of the
information for an individual patient be on the same row, even multiple
visits.
Is there anyway to combine the data in Excel? Someone told me that MS Access
might be better suited for this type of analysis. Is that true?
Thanks in advance for any help and sorry for the long post!
JG
I'm working with a large excel file (13,000+ rows) of cancer cases recorded
in the state of Florida. Each time a patient presents with a cancer, that
"case" is recorded as a row on the spreadsheet, along with a UNIQUE patient
ID assigned to that particular individual. If that same person develops
another cancer sometime later, that information appears in a new case/row,
but with the SAME patient ID.
I need to export this file to another program (SPSS v13.0) to do some
advanced statistical analysis. However, the program requires that all of the
information for an individual patient be on the same row, even multiple
visits.
Is there anyway to combine the data in Excel? Someone told me that MS Access
might be better suited for this type of analysis. Is that true?
Thanks in advance for any help and sorry for the long post!
JG