Hello!
Currently, I have a set of raw data that has a time-stamp for each question, each session and for each individual. For example:
<tbody>
</tbody>
I would need to transpose and combine the data to the following format, in a separate worksheet; so with 1 glance, I can see the time stamp for each subject, with session number and question number grouped together (i.e. session 1a, question 1).
<tbody>
</tbody>
I've tried various formulas, including using nested "index", but I just can't seem to get Excel to understand what I'm looking for. Pivot table can't seem to work as well, since I only wanted Excel to retrieve the timestamp, instead of summing them/averaging them. I am sure that all my formulas is wrong and since the amount of data that I have to deal with is extensive, and there is no way that I am going to do this manually. Any help will be very helpful!
Currently, I have a set of raw data that has a time-stamp for each question, each session and for each individual. For example:
Subject | Session | Question | Time |
1 | 1a | 1 | 08:59:22 |
2 | 1a | 1 | 09:00:13 |
1 | 1a | 2 | 09:01:58 |
2 | 1a | 2 | 09:01:33 |
1 | 1b | 1 | 08:33:24 |
2 | 1b | 1 | 08:31:22 |
<tbody>
</tbody>
I would need to transpose and combine the data to the following format, in a separate worksheet; so with 1 glance, I can see the time stamp for each subject, with session number and question number grouped together (i.e. session 1a, question 1).
Subject | Session1a_Question1 | Session1a_Question2 | Session1b_Question1 |
1 | 08:59:22 | 09:01:58 | 08:33:24 |
2 | 09:00:13 | 09:01:33 | 08:31:22 |
<tbody>
</tbody>
I've tried various formulas, including using nested "index", but I just can't seem to get Excel to understand what I'm looking for. Pivot table can't seem to work as well, since I only wanted Excel to retrieve the timestamp, instead of summing them/averaging them. I am sure that all my formulas is wrong and since the amount of data that I have to deal with is extensive, and there is no way that I am going to do this manually. Any help will be very helpful!
Last edited: