Skip to Content
0
Aug 18, 2015 at 11:11 AM

Reverse Pivot with Data collision problem!

2015 Views

Hi Experts!

I am facing Data collision problem while using reverse pivot transform in my program.

Currently I have more than one row with the same key and value in the source column. And I need to convert the output from row to column level data and due to collision I am not able to convert the same.

with the option "Input data is grouped" and "Duplicate value", "First Row/ Last Row" I can get the 'First row duplicate value' or 'Last row duplicate value' but instead I need to get all the duplicate row data into column level data.

Example

I followed 2-3 suggestions available on internet but end up having data collision problem.

Kindly suggest.

Please help.