View with uniq values as fields

[Vlad_Lehelt]

I have a table:

• team(text) - activity(text) - month(YYYY-MM) - allocation(float>0)
• team(text) + activity(text) + month(YYYY-MM) - is unique

I need view where:

• I can edit allocation values
• every unique month seen as filed: team(text) - activity - month1 - month2, - month3…
• cells are allocations

In excell/spreadsheed Icando it in pivot table.
But it’s not editable view.