vendredi 27 février 2015

Convert vector to matrix in Excel

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