Hi Guys,
I have a requirement on transpose paste.
Transpose copy paste multiple columns of a single row to a multiple rows in a single colum.
Present Sheet:
FirstName abc def ghi LastName pqr stu vwx xyz Address addr1 addr2
Required as:
FirstName abc FirstName def FirstName ghi LastName pqr LastName stu LastName vwx LastName xyz Address addr1 Address addr2
Any help is appreciated and thanks for the help guys
Bookmarks