You are reading a single comment by @NotThamesWater and its replies. Click here to read the full conversation.
  • Anyone on here use powerpivot for Excel?

    I just want to add a unique index for each row (i.e. 1, 2, 3, etc) but can't figure out how and can't find anything on Google. (My data is 4m lines long so can't do it in Excel).

    Cheers
    Chuck it in ms access if you're on a windows box with office installed.

    Or, if it's just a big flat file, you can use any number of free editing tools.

About