Emacs org mode is useful for this. Its plain text tables have spreadsheet capabilities and you can cross reference other tables, to separate out things.
emacs org mode tables can even have formulas embedded in it and do rotations and automatic recalculation.