Forum Discussion
Romy_Yourex
Nov 23, 2021Copper Contributor
Merging multiple persons residing at the same address into one household address
Hello, Does anyone happen to know of a way to merge multiple household members, residing at the same address, into one address for the household? I.e. Jane Doe, 4 Cherry Lane, T0M X02, Calgary, ...
Riny_van_Eekelen
Nov 24, 2021Platinum Contributor
PeterBartholomew1 Indeed, PQ can do this very easily. Couldn't resist to demonstrate it. See attached.
PeterBartholomew1
Nov 24, 2021Silver Contributor
Thanks for that. When I tried 'Group', PQ returned a column of Tables, each containing entire records.
Did you get the combined text from the GUI or is it a typed command?