I have data like following:
A 2015-02-26 0
B 2015-02-26 1
C 2015-02-26 2
D 2015-02-26 3
A 2015-02-27 4
B 2015-02-27 5
C 2015-02-27 6
D 2015-02-27 7
I would like to have matrix like this:
2015-02-26 2015-02-27
A 0 4
B 1 5
C 2 6
D 3 7
Using pivot table I only receive:
2015-02-26 2015-02-26 2015-02-26 2015-02-26 [....]
A 0
B 1
C 2
D 3
[...]
Of course I am trying to do this in Excel (mine version is 2013)
Aucun commentaire:
Enregistrer un commentaire