Dear all,

I have this type of table:
ID Date Culture ID Culture type Sample result
1 1 Jan 2022 001 MGIT Positive
1 1 Jan 2022 001 LJ Positive
2 1 Jan 2022 001 MGIT Negative
2 1 Jan 2022 001 LJ Positive
2 2 Jan 2022 002 MGIT Positive
I would like to transform it into:
ID Date Culture ID MGIT LJ
1 1 Jan 2022 001 Positive Positive
2 1 Jan 2022 001 Negative Positive
2 2 Jan 2022 002 Positive
Could you please help me with the syntax that I could use?

Thank you in advance.