Forum Discussion
Solved
Pull Row Values to Specific Columns
Hello, I have been trying to find a solution for a table I have been working on. I have multiple columns, but each column only needs one row of data per date. I need to keep the column nam...
Thank you for the feedback and tips to try. How I resolved it was I unpivoted the metrics columns, merged the metrics with the attributes, pivoted again and removed the columns not required.
Hi, Celine2022
I think you can remove the column 'Attribute' and the group table by column 'Date'.
Best Regards,
Community Support Team _ Eason