Copying Data from Sheet1 to Sheet2 with condition

Hi everyone,

Good evening. My first post here and happy to be a part, to learn and to contribute. i am posting a thread today to kindly get some help. I am new to VBA excel and i am working on a task. Please see the attached excel sheet; what I would like to get is,

1. Copy and paste data from Sheet1 into a sheet and that sheet data should be categorised according to the tests.

The final output should look like how it is in Sheet2. (Please note that there is no "Test C" on Sheet 2)

Any help would be very much appreciated.

Very much looking forward to replies.

Thanks guys!!