Transpose copy paste multiple columns of a single row to a multiple rows in a single colum

**Maheedhar** · 05-25-2013, 05:41 AM

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

**HSV** · 05-25-2013, 06:22 AM

Try this once.

The result is on Sheet2

Please Login or Register  to view this content.

**Maheedhar** · 05-25-2013, 06:51 AM

Thanks for the inputs HSV, but it didnt worked for my requirement

Do you think i need to change anything in the macro you have suggested

**Maheedhar** · 05-25-2013, 07:06 AM

Heyy Harry...
Didnt run it correctly before... you are awesome man... great... thank you very much.. it worked for me

Thanks,
Mahee

**HSV** · 05-25-2013, 07:08 AM

What is not working for your requirement.

Edit: Okay it's working; my pleasure.

**AB33** · 05-25-2013, 07:12 AM

Please Login or Register  to view this content.

Transpose copy paste multiple columns of a single row to a multiple rows in a single colum

LinkBack

Thread Tools

Rate This Thread

Display

Transpose copy paste multiple columns of a single row to a multiple rows in a single colum

Re: Transpose copy paste multiple columns of a single row to a multiple rows in a single c

Re: Transpose copy paste multiple columns of a single row to a multiple rows in a single c

Re: Transpose copy paste multiple columns of a single row to a multiple rows in a single c

Re: Transpose copy paste multiple columns of a single row to a multiple rows in a single c

Re: Transpose copy paste multiple columns of a single row to a multiple rows in a single c

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions