+ Reply to Thread
Results 1 to 4 of 4

Transpose column and skip two rows

  1. #1
    Registered User
    Join Date
    07-11-2016
    Location
    Honolulu, HI
    MS-Off Ver
    2015
    Posts
    3

    Transpose column and skip two rows

    Column data runs from B5-B68 (64 Cells)

    I need to transpose this column into a row starting at B72, but skip two columns (or cells to the right) where I will place two separate log functions.

    Are any of you familiar with this equation? I can't figure out whether I need to use INDEX or INDIRECT.

    I attached the data in case it helps. Thank you.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-08-2016
    Location
    USA
    MS-Off Ver
    Office 365, Office 2016 for PC & Mac, Office 2013, Office 2011 Mac
    Posts
    80

    Re: Transpose column and skip two rows

    jrmichal,

    Sorry for the short response, but this should at least get you started.


    Please Login or Register  to view this content.
    Other options would be sumifs, sumproduct, vlookup, hlookup. If you need the blanks to be blank, then you can an use and if function with "" or True then F5(Go To Special: formula-logical then delete).
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-11-2016
    Location
    Honolulu, HI
    MS-Off Ver
    2015
    Posts
    3

    Re: Transpose column and skip two rows

    I struggle with syntax sometimes, I knew I was missing a $ somewhere in the function. Thank you. I will see if it works and check back here!

  4. #4
    Registered User
    Join Date
    07-11-2016
    Location
    Honolulu, HI
    MS-Off Ver
    2015
    Posts
    3

    Re: Transpose column and skip two rows

    **Yep! I just had to make a few adjustments to the cell lookups, but otherwise it was a great help! Thanks again.

+ 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. Transpose and skip rows/columns when linking between sheets
    By MidasMax in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2016, 04:34 AM
  2. Replies: 3
    Last Post: 08-02-2015, 03:50 AM
  3. How to skip rows when referencing another workbook that doesn't skip rows?
    By Julian2501 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-06-2014, 04:55 PM
  4. Copy formula down column but need to skip 'n' rows
    By wschultek in forum Excel General
    Replies: 18
    Last Post: 03-12-2014, 03:24 PM
  5. [SOLVED] drag down rows that match column in different sheet, but skip every 3 cells in column
    By mbkr29 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2013, 01:43 PM
  6. [SOLVED] How to skip rows with value in a column using next available row code
    By fremarco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2012, 01:01 AM
  7. Insert rows, transpose data from column in to rows, in steps
    By mchevalier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2012, 08:14 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