Reorganizing a table by making the entries in original column as the columns of the new table

I am trying to automatically, or with minimal effort as possible since it will be a routine task, reorganize a data table by making the entries of one column as the columns in the new table. I appreciate any help!

Here is an example of what I mean

So in the above example, each run becomes a column with the respective compound results. The amount of compounds in each run can vary, and new data sets would need to be processed. Ideally, you could copy and paste a new set below the original data and have it reorganized as well.

I've made some attempts with this in the past, such as using xlookup in a separate table for each compound, but its always been clunky.

Thanks in advance for the help!

Edit: On Office 365