Creating a Unique ID from Multiple Rows of Data

[mccook]

Hi,

I have data a little like this:

Field	Value
IP	812
Site	North
Service	Acme
IP	813
Site	South
Service	Acme
IP	814
Site	North
Service	Bang

I know that the data that belongs together is on 3 rows, e.g. 1,2 and 3 is one record, 4,5,6 is another and so on.

What I need is:

IP	Site	Service	Unique ID (created)
812	North	Acme	1
813	South	Acme	2
814	North	Bang	3

Any advice appreciated, as I have no control over the data format I'm receiving.

Cheers,

Dean

[vamsee]

Thanks Saran

[mccook]

Perfect, Thanks for your help