-1
I have a list:
date item name quantity
1.7.2014 A 5
1.7.2014 B 2
1.7.2014 C 10
2.7.2014 B 5
3.7.2014 A 1
4.7.2014 A 7
I want this list as below table in excel
ITEM NAME 1.7.2014 2.7.2014 3.7.2014 4.7.2014
A 5 1 7
B 2 5
C 10
How do I do this?
1use Pivot tables – Sathyajith Bhat – 2014-09-13T12:35:32.813
no because pivot tables aggregate data and this is not what is being asked for – adolf garlic – 2015-12-22T07:47:15.483