Forum Discussion
Solved
Help Creating a Table to Average Multiple Different Columns
Hello! I currently have a table that I am importing that includes 48 columns in it. These are each labeled "Ch01", "Ch02", "Ch03", and so on. I am trying to create a new table which contains 2 c...
Hi, Jacob-Celadon
You can try the following methods.
sample data:
In the Power query-Select these 3 columns-Transform-Unpivot columns:
Result:
Is this the result you expect? Please see the attached document.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Jacob-Celadon
You can try the following methods.
sample data:
In the Power query-Select these 3 columns-Transform-Unpivot columns:
Result:
Is this the result you expect? Please see the attached document.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.