Results 1 to 13 of 13

Copy Data from one sheet to other to change data layout

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Copy Data from one sheet to other to change data layout

    Hello:

    I am trying to copy large amount of data from sheet1 to sheet2 to change the data layout.

    Please refer to attached sheet which shows the result i need in sheet2 (i have manually copied)


    Look for digit number like 1,2,3,4,5 and so on in Column A of Sheet1.
    Once found, copy data from column A to L for that particular row in Sheet2 starting at cell A2.
    Copy the next 2 row (1st 2 column) of data in sheet2 column M,N,O,P as shown in sheet2.

    I would appreciate if someone can help with this ASAP.

    Thanks a lot

    Riz
    Attached Files Attached Files
    Last edited by rizmomin; 11-29-2012 at 10:36 PM.

Thread Information

Users Browsing this Thread

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

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