Merge Two Tabs Data into one to generate Unique List RRS feed

  • Question

  • I have imported two CSV files into power pivot.

    Tab1: ID, Name, Date

    Tab2: ID, Account, Post

    I wanted combine Tab1 and Tab2 and generate unique 'ID' based on data in the two tabs. So everytime I refresh the data in powerpivit it should generate unique list for me.

    I am using Excel 2010 and  PowerPivot 10.50.4000.0

    Thursday, August 14, 2014 8:41 PM


All replies