Log In
Register
Home
February 20, 2019
Offline
How can I combine kids' first names using formulas if they have the same parents?
1. If there is only one child, then we lease it as it is.
2. There are two kids, and their first names are A and B, respectively, then we combine their first names as A & B.
3. There are three kids, and their first names are A, B, and C, respectively, then we combine their first names as A & B & C.
Only up to three kids, the most.
Moderators
January 31, 2022
Offline
Added a formula based solution to the file I uploaded with my answer to the same question, asking for a PQ solution.
See attached.
February 20, 2019
Offline
Riny,
Yes, you have answered my question with the Power Query solution. It worked perfectly. Appreciated.
Now, I am looking if there is any formula (solution) I can apply to the table without resorting to Power Query.
Thanks!
Jim
Moderators
January 31, 2022
Offline
The formula based solution is in the file I attached earlier. Or did I miss something?
February 20, 2019
Offline
Riny,
I am sorry that I missed it. I checked it again and saw the solution. It is perfect. Thanks!
What would you recommend, formula or Power Query? Do you happen to know Power BI?
Appreciated!
Moderators
January 31, 2022
Offline
Whatever you prefer. PQ is great for big data sets, but formulas work great as well. It may be more work to maintain them when the underlying data changes, but they don't need a Refresh. So, I have no real preference. It depends on the situation.
Regarding Power BI, yes I use it, but I would not call myself a real expert.
1 Guest(s)
