Group values in a dimension column

[#1]

Hello QGurus  – In the attached qvw, we can see the raw data and equivalent representation in pivot table. However, my customer is expecting output in one of the following format. Any guidance on how we might achieve it without having to modifying the raw data? Many thanks!

Expected Output

Raw Data

LastName	FirstName	Parents	Child
Morgan	Debra	Doris	Nicholas
Morgan	Debra	Harry	Nicholas
Morgan	Dexter	Harry	Astor
Morgan	Dexter	Harry	Cody
Morgan	Dexter	Harry	Harrison
Morgan	Dexter	Laura	Astor
Morgan	Dexter	Laura	Cody
Morgan	Dexter	Laura	Harrison

Pivot Table We're Looking to Modify

[ramoncova06]

I dont believe this is feasible

[#3]

Thank you for your input @Ramon!

[#4]

Any other guidance Qlik Gurus?