using SQL Server 2008

its difficult to explain but actually easy to see.

I have a table:

DeviceHistory
ID
DevID
Value1 (varchar)
Value2 (varchar)


Value1 contains things like:

serialnumber
manufacturercode

think of them as sections/columns/groups. or even better: a heading title.

value2 contains - its related value.

I want to pull results from that table for each of the headings (value1) where the value2 is duplicated but for different DevIDs

makes sense?