How do I use the group summary/unstack function in this script?

1 view (last 30 days)
This is my script:
date1 = datetime(2020,10,12,'Format','yyyy/MM/dd');
date2 = datetime(2020,10,15,'Format','yyyy/MM/dd');
Date = [date1;date1;date1;date2];
Concept = ["Petrol";"Woolworths";"ALDI";"Opal Card"]; T
ype = ["Credit";"Savings";"Cash";"Credit"];
Category = ["Car";"Groceries";"Groceries";"Transportation"]
; Amount = [55;63;15;20];
T = table(Date,Concept,Type,Category,Amount)
It looks like this
I am trying to create another table to reflect these results:
I tried using groupsummary function but it would only allow me to use the variables of the columns and not the two dates I need.
Is anyone able to point me in the right direction?

Answers (1)

Seth Furman
Seth Furman on 16 Oct 2020
Take a look at the following documentation example for unstack, which closely resembles your problem.

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!