hi,
I have a long list that shows a date (col' A) the hour (col' B) and a metric that I have chosen (col' C) .
something like this:
date (A) hour (B) metric (C)
01/01/2015 01:00 55
01/01/2015 02:00 66
01/01/2015 03:00 77
and so on...
I've want to change the order of the data >> instead of getting a line for each date i will get a col' for each date (and the hours will be the rows- corresponding with their metrics)...
something like this:
col' A col' B col B' col' C
01/01/2015 02/01/2015 03/01/2015 04/01/2015 ... .... ....
00:00 metric metric metric metric
01:00 metric metric metric metric
02:00 metric metric metric metric
03:00 metric metric metric metric
04:00 metric metric metric metric
...
...
...
...
help(?)
cheers!
Bookmarks