How to consolidate this data

[k31453]

Hi, I have two entries for this productid, Is it possible to consolidate to one entry maybe with evals?

productid	field1	field2	field3
abc	test
abc		week1	3

[to4kawa]

|selfjoin productid

[ITWhisperer]

| stats values(*) as * by productid