Smartsheet.com allows hierarchical representation of data in a single sheet {without having to use adjacency lists}. Example.

Do Google Spreadsheets support hierarchical (nested) data in a single spreadsheet, without using adjacency list?

If not, what alternative approaches are supported by Google Spreadsheets?


Not supported but technically can do workarounds:

  • For columns - put in separate columns and use JOIN(" "; [columns to join]), i.e. separator could be just space or some other symbol. According sample: Column A for Administration; Column B for 2nd level; Column C for join("_"; A:B) should produce nested list.
  • For rows - use Autofilter
  • The question says "without using adjacency lists". The use of JOIN requires adjacency lists.
    – Rubén
    Aug 31 '17 at 16:33

This site is temporarily in read only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .