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.
Added a formula based solution to the file I uploaded with my answer to the same question, asking for a PQ solution.
See attached.
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
The formula based solution is in the file I attached earlier. Or did I miss something?
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!
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.
