Forum Discussion
Solved
Pivot creates duplicate values
Hi All, I am trying to create a pivot for different types in a column. However, it creates multiple TIDs based because of the pivot. I am aware that I can use fill up or fill down so that I ...
Hi labuser1235 ,
Remove the FID column and pivot Fname column with Fdata as value column should work.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
labuser1235 Looking at the data this seem like case of matrix with TID as row Fname as column and Fdata value.
I am missing something?
Hi Amit ,
I was expecting to have the output saved in another table with the help of transformations if any with power query so that I can club that with another values in the table visual. Hope this is clear.