Move data from existing column to new columns in Sequel pro

Question

I need help with my SQL table, so thank you in advance for any comments. My table in Sequel Pro (example):

Object	Time	Intensity
. A.	. 1.	. 100.
. A.	. 2.	. 150.
. A.	. 3.	. 300.
. B.	. 1.	. 150.
. B.	. 2.	. 300.
. C.	. 1.	. 80.
. C.	. 2.	. 100.
. C.	. 3.	. 140.
. C.	. 4.	. 200.

And I would like it to look like this:

Time	A	B	C
. 1.	. 100.	. 150.	. 80.
. 2.	. 150.	. 300.	. 100.
. 3.	. 300.	. NULL	. 140.
. 4.	. NULL	. NULL	. 200.

Thanks!