This video is showing how to make table with all hierarchy levels from one column that includes hierarchy with multiple levels where each level has different indent.
To get indent number I created own function using following VBA Code:
Public Function IndentLvl(CellRef As Range) As Long
IndentLvl = CellRef.IndentLevel
End Function
If you have any questions please comment below.
Enjoy :)
Excel - How to use indent to transform hierarchy into table
Теги
indentVBA functionExcel functioncreate functionget indentcell indentleft alignmentexcel hierarchyhierarchyExcel tips and tricksExcel TipsExcellent IdeasMicrosoft ExcelMS ExcelExcel 365
excel basicsexcel tutorialhow to use excelmicrosoft excel basicsmicrosoft excel tutorialmicrosoft excel tutorial for beginnersexcel formulasexcel functionsExcel helpExcel how toexcel basicsHelp with excelhow to excelhow to use indent