How to display all the data from a cell value which contains sub-rows or rows within a row.

How to display all the data from a cell value which contains sub-rows or rows within a row.

For a table visualization, there can be a scenario where we have rows within a row and in that case only the topmost row within that cell is displayed. This article describes how we can display all the sub rows within a cell value.
  Go to Properties >> Appearance >> Data rows height (number of lines) >> Increase it to a suitable height such that all the sub-rows are displayed (By default it is set to one because of which all the sub rows are not visible).

Please refer to the attached GIF below



NOTE: This setting is evenly applied for all the rows and so there can be empty spaces where sub-rows are less or absent.