How Can I Transfer My Column As Value In Other Column In SQL

Database
Visitor

How Can I Transfer My Column As Value In Other Column In SQL

How Can I Transfer My Column As Value In Other Column, When I Use DENSE_RANK() In My Query?

Situation-One:

 

Sit1Sit1

  Situation-One Must Change To Situation-Two:

Sit2Sit2Thanks.