+ Reply to Thread
Results 1 to 5 of 5

Using OFFSET &/or TRANSPOSE functions to copy multiple rows of data into multiple columns

  1. #1
    Registered User
    Join Date
    03-08-2013
    Location
    Greece
    MS-Off Ver
    Excel 2010
    Posts
    3

    Using OFFSET &/or TRANSPOSE functions to copy multiple rows of data into multiple columns

    Hello forum users,
    First time user here. I want to correctly select and then copy the 1st, 3rd, 5th etc. rows of data (each of which has three columns) into one new, wide, row, which places side by side each of the three rows of data. I've tried sorting this out with the OFFSET function but can't manage to copy the data into the correct cells. I'm not a VBA user, so marcos would be hard for me to follow. I've also had a look at the INDEX fiunction to no avail. All the particulars of my data, what I've tried and what I would like to achieve are in the attached spreadsheet.
    Any assistance/guidance would be greatly appreciated.
    Thanks,
    Demip.
    Attached Files Attached Files

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Using OFFSET &/or TRANSPOSE functions to copy multiple rows of data into multiple colu

    Ηι. Καλημέρα!

    Do you mean?

    =OFFSET(Sheet1!A$1;(ROW()-1)*2;0)

    Copy down and across.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    03-08-2013
    Location
    Greece
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Using OFFSET &/or TRANSPOSE functions to copy multiple rows of data into multiple colu

    Efxaristo for your quick reply Fotis. I've got the [OFFSET(A$1,(ROWS($1:1)-ROW($1:1))*2,,)] working just fine (please see my spreadsheet) but am having troubles getting the output into one wide row. Hope this makes sense?

  4. #4
    Registered User
    Join Date
    03-08-2013
    Location
    Greece
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: SOLVED - Using OFFSET &/or TRANSPOSE functions to copy multiple rows of data into

    Sorted now, thanks gain Fotis. Have a good weekend, Demip.

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Using OFFSET &/or TRANSPOSE functions to copy multiple rows of data into multiple colu

    Have a good weekend too.

    Can you share the solution with us?

+ Reply to Thread

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