Excel convert multiple columns to dataset based on unique timestamp

Question

I want to convert Excel from one output to another for Google Maps CSV (Formula or how to accomplish it).

upload to plot data on maps. Example: Original CSV: 

The expected output for mymaps API: 

Also, note that these coordinates are not constant and change across the city or state.

Answer 1

F2  =UNIQUE($B$2:$B$20)
G2  =FILTER($C$2:$C$20;($B$2:$B$20=$F2)*($A$2:$A$20=G$1))
H2  =FILTER($C$2:$C$20;($B$2:$B$20=$F2)*($A$2:$A$20=H$1))