Is there any way I can get a parent line item and then its Child Line items in the Column?
if not is there any other way i can get something like this?
Child: M1, M2 and M3
Note: Parent should come in center like Merged Cells
Could you please explain it in detail.? Any screenshot or excel template for what you trying to achieve would be helpful.
FYI, You can have child and parent in the column but, not as merged cells.
Not a lot of detail, but if you are trying to get this on a dashboard you could just create two different views, one at the Parent Level, one at the Child Level and setup synchronized selection.
If you are just trying to concatenate all Child values to the parent level, you could use TEXTLIST