Get data from one column in 2 different columns

Question

Hello,&nbsp;If I have these 2 tables:&nbsp;id&nbsp; &nbsp; &nbsp; name&nbsp; &nbsp; &nbsp; age1&nbsp; &nbsp; &nbsp; &nbsp;Jack&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;232&nbsp; &nbsp; &nbsp; &nbsp;Peter&nbsp; &nbsp; &nbsp; &nbsp;343&nbsp; &nbsp; &nbsp; &nbsp;Loic&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;56&nbsp;Id&nbsp; &nbsp; &nbsp; &nbsp;UserId&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;feature&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; value1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; eyes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;brown2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;male3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; eyes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blue4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; male5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; eyes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;brown6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;female&nbsp;And I would like to get the following data extend, how I can get it?&nbsp;id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; age&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; eyes&nbsp; &nbsp; &nbsp; &nbsp; sex1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jack&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; brown&nbsp; &nbsp; &nbsp;male2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Peter&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blue&nbsp; &nbsp; &nbsp; &nbsp; male3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Loic&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 56&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blown&nbsp; &nbsp; &nbsp; female&nbsp;

mfelix · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
You need to do the following steps:

Table2:

Select columns feature and value
Pivot columns without aggreagation of values
Fill down&nbsp; on eyes column
Fill up on sex column
Remove ID column
Remove duplicates

Table1

Merge with table2
Expand sex and eyes column

Check PBIX file attach.
&nbsp;

Forum Discussion

Get data from one column in 2 different columns

1 Reply

Related content

New Column

Create a Column where sum two columns from different tables

Grouping rows by Column and then updating Column

Different Groupby Column Names in Summarize

Need column level difference