how do i build this data into a excel spreadsheet. please see attachement

Assignment: Build a Dataset in Excel Instructions Using the 20 data collection sheets posted, create a data set in Excel. Each variable should be . represented in 1 column. Each participant should be represented in a single row. If there are any categorical variables (i.e., nominal or ordinal levels of measurement), make sure that you create a method of coding those variables, For example, if you had the variable of gender, you could assign all males a value of 1 and all females a value of 2. "Blood pressure (5)" is systolic pressure and "Blood pressure (D)" is diastolic pressure. Data Collection Sheets Data sheet: #01 Age: Temperature: 98.6 Height: 66 Heart rate: Weight: 120 Respiration: 16 BMI: 19.4 Smoking: No Blood pressure (S): 120 Diabetes: No Blood pressure 80 (D): Data Sheet: #02 Age: 20 Temperature: 98.9 Height: 68 Heart rate: 70 Weight: 160 Respiration: 15 BMI: 24.3 Smoking: Yes