Excel convert multiple columns to dataset based on unique timestamp

Question

I want to convert(Formula or way to do it) excel from one output to another for google maps csv upload to plot data on maps. Example: Original CSV:

Expected output for mymaps API:

Also note that this coordinates are not constant and changing across the city or state.

Attempt 1) Manual but dataset is too large Attempt 2) Text to Column but that only supports via delimiters

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))