Hi,

Im not sure where I should put my question.


My problem.

I am importing file using powerpivot in excel 2010.
I want to add column to my data, with unique value.

It seems to automatically copy first value in first row, to the last row.

I neeed unique value because I am linking two tables.