Concatenate in PQ

Hello
Dear forum, I need your help again.
I have attached a file with the initial situation and desired result in PQ. Who could help me?
Thank you in advance for your great help.
greeting
Ivan-

U	U.X	K	K.X	50	50.X	75	75.X
Herbert	x	Name4		Katze		Name01
Ludwin		Name9		Hund	x	Name09
Caro		Name21		Esel		Name03	x
Felix		Name42	x	Vogel		Name07
Sindra				Dachs
Group	Name
U	Herbert
K	Name42
50	Hund
75	Name03

Hello
@Sandy666
First of all thanks for your SCNELLE answer.
I also looked at your solution. Unfortunately I do something wrong.
If I at Sindra an X in column andx so this name is not shown to me, what am I doing wrong?

Hello
@ Sandy666
Thank you very much for your help, now it will work out as desired.
@Hansdouwe
Thanks also for your solution, which unfortunately cannot use in this case, but is definitely used in another project.
@All
Just as a question?
a) Is it possible to use columns to use columns variably ??
b) How can you variable all columns format as text?

Originally Posted by Ivan-

a) Is it possible to use columns to use columns variably ??

explain by example

Originally Posted by Ivan-

b) How can you variable all columns format as text?

1. select all columns
2. Transform tab
3. Data Type: Text

Hello Sandy666
Thanks again for the quick feedback.

To my question B with text format:
Yes, I had done that, these columns are formatted as text, now what I meant variably is if new columns should be added as text without making changes in the M code. Or is this not possible?

To my question a chain with:
Here, too, the columns should be variable when new columns are added without changing the M code.
Example:
U and U.X should become u as she did in the M code with the sign of equality.
Now, for example, is added:
K and K.X should become K without that I still have to mean the chain.
Hope it is explained so understandable. Or is this not implementable?

if you want to combine columns, they must be text, especially with numeric data, because otherwise they will either format themselves to text (in a special case) or you will get an error
Table.CombineColumns() is a text function and that's the whole explanation

---

if the problem is solved, make me happy and hit Add Reputation (bottom left corner next to the post that was helpful) (if you did it - ignore this)

Hello sandy666

Thank you for your explanation.
I can't explain it better, that's why I close the post.
Thanks again for the quick help.

welcome

---

if the problem is solved, make me happy and hit Add Reputation (bottom left corner next to the post that was helpful)

I deleted the last two steps from sandy's solution and then it does show the correct names when an X is placed or deleted

Originally Posted by Roel Jongman

I deleted the last two steps from sandy's solution and then it does show the correct names when an X is placed or deleted

I think you are wrong
letters should be grouped (single values)

could be.. after reading the last few replies it seems that was about a second (b) question I missed.

My interpretation to what the topicstarter wants is that beside U, K, 50 and 75 now being in the M code as he also wants new kolom sets added to be automaticly included in the list.
so there can be more then 4 sets of 2 columns with relevant data that should be in the result list

based on your solution that would mean (i think) that steps MC1 thru MC4 should be replaced by a custom function or other way that determines how many columns/data sets there are.

I do not have the skill yet to build that but maybe this helps to get the topic going again.

@Roel Jongman
I suggest to create your own solution not use from others then we can talk
it was tailored to the example from post#1 and I don't have time to guess