Convert multiple row data into columns

For your reference.

Step 0: I use these data.

DATA:

Date Store No Category Outcome Name Visit Type Job Title Store Size
02/10/2023 4567 1a Good Mickey Mouse Visit Manager Small
02/10/2023 4567 1b Satisfactory Mickey Mouse Visit Manager Small
02/10/2023 4567 1c Improvement Necessary Mickey Mouse Visit Manager Small
02/10/2023 4567 1d Not Checked Mickey Mouse Visit Manager Small
02/10/2023 4567 2 Good Mickey Mouse Visit Manager Small
02/10/2023 4567 3 Good Mickey Mouse Visit Manager Small
02/10/2023 4567 4 Good Mickey Mouse Visit Manager Small
08/10/2023 2345 1a Satisfactory Donald Duck Desk visit Senior Manager Large
08/10/2023 2345 1b Improvement Necessary Donald Duck Desk visit Senior Manager Large
08/10/2023 2345 1c Not Checked Donald Duck Desk visit Senior Manager Large
08/10/2023 2345 1d Good Donald Duck Desk visit Senior Manager Large
08/10/2023 2345 2 Good Donald Duck Desk visit Senior Manager Large
08/10/2023 2345 3 Satisfactory Donald Duck Desk visit Senior Manager Large
08/10/2023 2345 4 Improvement Necessary Donald Duck Desk visit Senior Manager Large

Step 1: I add 7 conditional columns.

Step 2: I fill down these 7 columns.

Step 3: I filter 'Category' column by '4'.

Step 4: I remove 'Category' column and 'Outcome' column.