Remove Blank rows from a Hierarchy in a matrix table.

[San_Raz]

I am having a table where there are heirarchical parental levels to the Name column.

Level 1	level 2	Level 3	Level 4	Name
A1	B1			Activity 1
A1	B2	C1	D1	Activity 2
A2	B3	C2		Activity 3
A3				Activty 4

When I create a matrix table, some of the parent levels of the name columns are blank. But the matrix table doesnt recognize this and creating a blank rows for each levels as shown below.

I wanted to remove the blank rows and only display the levels where there is a value as displayed below

[lbendlin]

While it is possible to prune dead branches with custom visuals  you seem to want to collapse branches with dead parents. That is not currently possible in any visual, and it will most likely result in user confusion anyway.  Better cleanup your data.  There should be no blank parent elements in any hierarchy.