Compare the contents of a single column and sync rows in that colum
Is this what you're looking for?

Set up demo table with data

declare @T table (ItemNumber int, location int, price decimal(11,2))

insert into @T (ItemNumber,location, price) values
(1,1,10.00),(1,2,20.00),(1,3,30.00)

select * from @T




| ItemNumber | location | price |
|------------|----------|-------|
| 1          | 1        | 10.00 |
| 1          | 2        | 20.00 |
| 1          | 3        | 30.00 |




The update statement

UPDATE @T
SET price = (
        SELECT price
        FROM @T
        WHERE location = 1
        )
WHERE location &lt;&gt; 1

select * from @T




| ItemNumber | location | price |
|------------|----------|-------|
| 1          | 1        | 10.00 |
| 1          | 2        | 10.00 |
| 1          | 3        | 10.00 |