Do you plan to add tree like view with ability to collapse/expand rows? Would be helpful to create groups and subgroups.
have you tested nestedRows feature https://docs.handsontable.com/pro/6.0.0/demo-nested-rows.html We also have the same option for headers https://docs.handsontable.com/pro/6.0.0/demo-nested-headers.html