Excel – How to use indent to transform hierarchy into table

Excel – How to use indent to transform hierarchy into table

HomeOther ContentExcel – How to use indent to transform hierarchy into table
ChannelPublish DateThumbnail & View CountActions
Channel AvatarPublish Date not found Thumbnail
0 Views
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 🙂

Please take the opportunity to connect and share this video with your friends and family if you find it useful.