Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HIi,
I want to make the table below to this table
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7...
DATA1 DATA2 DATA3 DATA4 DATA5 DATA6
ANY IDEA HOW?
Solved! Go to Solution.
Yes, with the following code; replace Source with the name of your previous query step:
= Table.FromRows({Source[Column2]&Source[Column4]},Source[Column1]&Source[Column3])
Yes, with the following code; replace Source with the name of your previous query step:
= Table.FromRows({Source[Column2]&Source[Column4]},Source[Column1]&Source[Column3])
Thanks!
What do you suppose to do in this case ?
The code didn't work if I have null "headers" . I tried to create custom column and change null value to some different value like "1" but it didn't work
Hi, it is not.
It is different approach to solve my question.
The question in this topic is how can I use your code for transformation column with null values?
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |