HiTech was suggesting that, in your Temp Table, include a field [SortOrder] which would be numbered in the Order that your rows are currently displayed. I'm thinking you would have a table named "tblCycleRecordOrder" with fields CROrderID (PK AutoNumber), SortOrder, Identifier. Identifier would be the names in Column 1. Then join this table to your output query and have ORDER BY SortOrder.
Your sample database illustrates that you are treating MS Access (A Relational Database) as an Excel Spreadsheet. This is not how you would do it, and you would not have 'combo boxes' built directly in tables -- just raw data in tables.
As a start, I can imagine the following possible tables (not complete):
tblPeople
tblAddresses
tblPatients
tblPatientContacts
tblDiagnosisTypes
tblPatientDiagnoses
tblPatientVisits
tblVisitTypes
tblHospitals
tblDoctors
tblVisitPurposes
tblVisitAssessments
Just off the top of my head... Not in the Medical field, so more tables probably necessary for the rows after the Assessments. If this is your first attempt (?), I would suggest reading up on Database Normalization (search here or on Google) for tips on creating a Normlized Database Design. With the proper design, you can manipulate the data any way you wish. I would recommend trying to put something together, then when you have questions, make a post in the Tables/Relationships/Design Forum stating what your purpose is, any special requirements, and then provide your tables as you have them, such as:
tblDiagnosisTypes
----------------
DiagnosisTypeID, AutoNumber, PK
DiagnosisCode, Text
Description, Text (or Memo if needed)
...
tblPatientDiagnoses
---------------------
PatientDiagnosisID, AutoNumber, PK
PatientVisitID, Number, FK
DiagnosisTypeID, Number, FK
...