8 Replies Latest reply: Jul 13, 2018 6:32 PM by Lech Miszkiewicz RSS

    How to remove the duplicate records in Straight Table

    Gopi Krishna

      Hi Team, I have a straight Table with 11 Columns, in that i found 10 columns having duplicate records, so i want to display only one record from all 10 columns and in the  11th columns want to display the all unique records. I have attached the sample data and required output. Please help me, how to achieve this scenario. I used Pivot Table, but it is not working. Thank you.