Forum Discussion
Pivot Unpivot Multiple values
Hi friends - One of my data sources is a SharePoint list (created from SP forms) and is in the format below: Project Title Project Manager Risk Name 1 Risk Category 1 Risk Status 1 Risk Prio...
it's the #"Removed Columns" line. The pivot needs that column to identify unique rows.
So remove that step. You might want to filter out blank values from the Value column also.
Then do the pivot.
If you need to filter out rows after that then you can identify them at that stage.
If you don't filter out blank values (my suggestion in previous post), then you should still see Project4 rows after pivot
Thank you!