Hello SQL Expert,
I am working on a small test project and wondering if you could help me to update my query below.
SELECT Scientist_ID, Experiment_#1, Experiment#_2
Here is the output from above SELECT statement:
and here is the output that I am trying to achieve:
How do I update my above simple query?
Anyone could help me?
Thanks all for all your help