using splitapply on a table to split a column with repeating rows

Hello, I'm using splitapply but cannot seem to solve the following where I have an initial table as follows but want the final table. Fin_year is categorical, Type is categorical, but Quantity and the resulting City_quantity and Rural_quantity are numeric. Notice the repeating year row values in the initial table.

 Accepted Answer

See if the unstack function will do what you want.

4 Comments

I get this error message: Variable index exceeds table dimensions.
You will need to figure out what the problem is.
From the description in the documentation, it would appear to do what you want.
yes thanks, was missing the quation marks, it works now.

Sign in to comment.

More Answers (0)

Categories

Find more on Graphics Objects in Help Center and File Exchange

Products

Release

R2020b

Tags

Community Treasure Hunt

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

Start Hunting!