Forum Discussion
Create table using LET based on column values
The attached removes the rows with 0s.
For the columns, the width must match the width of the selected values (even if the columns are blank). If your example presents a differently arranged header then a sample may be needed.
Hi Patrick
Thanks for your time supporting me here.
I attach a live example of what dataset / table structure I am trying to apply this to.
You will see the top table (original data table) and the desired output I am looking for underneath.
If the Team result is empty, no data is shown in the desired output.
Your support is much appreciated
Matt
This will do it. The function is made specifically for this arrangement. Essentially, this is doing what PowerQuery would be doing with changing the order of columns and then unpivoting.
Thanks again Patrick. This works perfectly. Silly question but should I want to include another column from the initial table, is it just a question of updating the "matrix" range from say $A$2:$U$16 to say $A$2:$V$16?
Yes, that will work. Tested it here.