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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.