Forum Discussion

Celine2022's avatar
Celine2022
Frequent Visitor
4 years ago
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...
Need Help
  • Celine2022's avatar
    Celine2022
    4 years ago

    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.

PC2790's avatar
PC2790
Community Champion
4 years ago

Hey Celine2022 ,

 

You can try to group by on the date column.

Based on what logic you want the values(highlighted) for the three columns to be shown?