+ Reply to Thread
Results 1 to 3 of 3

Need to copy data from row cells to column cells

  1. #1
    Registered User
    Join Date
    12-17-2015
    Location
    Bangalore,India
    MS-Off Ver
    Office 2013
    Posts
    2

    Need to copy data from row cells to column cells

    Hi Guys,

    I am normal excel user. Here i have requirement of converting data's from rows to columns i.e., i want to re-arrange data from line to column, but i have more then 20 lines so first line datas to be filed in column and second line data to be added in same column next to first line data.

    How can i do that.

    Here is what i have

    HEAD1 DATA1 DATA2 DATA3 DATA4 DATA5
    HEAD2 DATA10 DATA11 DATA12 DATA13 DATA14
    HEAD3 DATA20 DATA21 DATA22 DATA23 DATA24

    Here is what I want

    HEAD1 DATA1
    HEAD1 DATA2
    HEAD1 DATA3
    HEAD1 DATA4
    HEAD1 DATA5
    HEAD2 DATA10
    HEAD2 DATA11
    HEAD2 DATA12
    HEAD2 DATA13
    HEAD2 DATA14
    HEAD3 DATA20
    HEAD3 DATA21
    HEAD3 DATA22
    HEAD3 DATA23
    HEAD3 DATA24


    Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Need to copy data from row cells to column cells

    You could use this code (copy from the first sheet to the second sheet):
    Please Login or Register  to view this content.
    Regards,
    Antonio
    Attached Files Attached Files
    Last edited by antoka05; 12-17-2015 at 07:04 AM.

  3. #3
    Registered User
    Join Date
    12-17-2015
    Location
    Bangalore,India
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Need to copy data from row cells to column cells

    Thanks Antonia,

    This worked exactly the way i wanted.

    Regards,
    Rajprasat A

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 30
    Last Post: 11-06-2015, 05:43 PM
  2. [SOLVED] Really hard!!! Copy data from column B to C and add empty cells.Please see example.
    By bonpara in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2015, 10:35 PM
  3. [SOLVED] Copy all cells in column that contain data & paste to first empty row of another column.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2014, 08:45 AM
  4. Copy alternate cells data from a Row to single Column
    By Subhash A. in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-06-2014, 09:13 PM
  5. [SOLVED] copy selected data into column A cells if column B contains text
    By El Conquistador in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-05-2013, 02:51 PM
  6. Replies: 3
    Last Post: 08-28-2012, 10:09 AM
  7. Copy Data Range Between Blank Cells in Column
    By rs235251 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-20-2011, 12:51 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1