how to remove duplicate rows

[gurusai sankar]

Hi All,

i am gettting some duplicate rows with same information. thatswhy my cost is getting higer values.

i have attched excel data whiehever extraxted from information link. kindly check and suggestthat how to workout this by putting some distinct or rank to get single line.

 

Regards,

Guru sankar

[Swen Vogel]

Hi,

Add a pivot transformation with all columns as Rowdescriptor or use and R script (unique is the keyword)

regards

Swen