Thanks for reply.

But this is not an answer to my question.

I dont want to copy from column and pate to row. Rather I wanna do lookup for the data in row and reference in column.