I have similar to this table with many columns and thousand of rows (patients)
- as you can see each patient have 6 tests(test1 to test6) with different 6 result.
- all other columns have the same result.
- I need to switch the results from vertical to horizontal so I the table can show one record for each patient. like table2
I hope this can be done in Access 2016 and also if possible in excel also.
I think this can be done only by code, if any one posted the solution please explain the steps how to paste the code in access (I never made a code)
thank you and hope this can be resolved.
BEFORE:
TABLE1
<tbody>
</tbody>
AFTER:
TABLE2
<tbody>
</tbody>
- as you can see each patient have 6 tests(test1 to test6) with different 6 result.
- all other columns have the same result.
- I need to switch the results from vertical to horizontal so I the table can show one record for each patient. like table2
I hope this can be done in Access 2016 and also if possible in excel also.
I think this can be done only by code, if any one posted the solution please explain the steps how to paste the code in access (I never made a code)
thank you and hope this can be resolved.
BEFORE:
TABLE1
FILE NO | RCVD DATE | COUNTRY | ID_NO | PID_NO | TEST | RESULT | REPORT DATE |
1 | 05/01/2018 | USA | 1234567890 | ABCDEFGH | TEST1 | NOT TESTED | 05/25/2018 |
1 | 05/01/2018 | USA | 1234567890 | ABCDEFGH | TEST2 | NOT TESED | 05/25/2018 |
1 | 05/01/2018 | USA | 1234567890 | ABCDEFGH | TEST3 | POSITIVE | 05/25/2018 |
1 | 05/01/2018 | USA | 1234567890 | ABCDEFGH | FINAL RESULT | POSTTIVE | 05/25/2018 |
1 | 05/01/2018 | USA | 1234567890 | ABCDEFGH | TEST4 | NOT TESTED | 05/25/2018 |
1 | 05/01/2018 | USA | 1234567890 | ABCDEFGH | TEST5 | NOT TESTED | 05/25/2018 |
1 | 05/01/2018 | USA | 1234567890 | ABCDEFGH | TEST6 | PENDING | 05/25/2018 |
<tbody>
</tbody>
AFTER:
TABLE2
FILE NO | RCVD DATE | COUNTRY | ID_NO | PID_NO | TEST1 | TEST2 | TEST3 | TEST4 | TEST5 | TEST6 | FINAL RESULT | REPORT DATE |
1 | 05/01/2018 | USA | 1234567890 | ABCDEFGH | NOT TESTED | NOT TESTED | POSITIVE | NOT TESTED | NOT TESTED | PENDING | POSITIVE | 05/25/2018 |
<tbody>
</tbody>