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

Database
Highlighted
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:

 

1.pngSit1

  Situation-One Must Change To Situation-Two:

2.pngSit2Thanks.