SQL Server :: How To Find The Last Column Value And Last Row Value

Create a user Define value to find the last column and last row value make a UDF in sql server

Table1
ID Name
Address
1 A
Delhi
2 B
Noida
3 C
GZB
4 D
Bihar
i say this way
Declare @v varchar(50)
Select @v = address
from Table
print @v

then he say me if rotate the colums like this it will never work

Table1
ID Address Name
1 Delhi
A
2 Noida
B
3 GZB
C
4 Bihar
D

then how would you do this then i say that i don't want the job in this company