Forum Discussion
Creating new column concatenating data from two or more rows
Please follow the steps shown in my file. I would not bother so much about the last comma becoming a &
When there are two (or more) different lastnames for members of the family, I'm good with using the lastname of the first person listed, so Alex Jones, Pam Carter & Samatha Jones would have Jones in the Family Sort column.
Just wanting to get a closer sort than having only a first name sort, like now.
Thanks!
Hi,
I cannot understand what the input table is and what the output table is?
The desired output is the Family Table with an additional column: Lastname.
Two possibilities: 1) For only one lastname, e.g., for John & Susan Brown it would be Brown OR 2) if there are multiple lastnames, then the first person's last name, e.g., Beth Williams & Andrew Peters it would be Williams.
Ibendlin asked, "What if Pam's name was Carter"... Then #2 above would apply.
I realize this isn't a perfect solution, but I just needing a better (closer) sort than having to rely on a matrix sorted by first name.
The "People" table is a secondary table available that could be used to create the solution (??). It just contains every individual with a linking field to their "family".
The PBIX file is available here: https://www.dropbox.com/scl/fi/lqmtrqarld385r3n0ujo0/Demo.pbix?rlkey=wvvh6su95upyzybxvdu71vywj&st=19kbc9bq&dl=0
Hi,
PBI file attached.
Hope this helps.