+ Reply to Thread
Results 1 to 5 of 5

Shortcut in Transposing Rows to Column

Hybrid View

  1. 03-05-2013, 01:04 PM #1
    outofthehat
    outofthehat is offline
    Valued Forum Contributor
    Join Date
    10-17-2010
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013, 2016, 2019, 365
    Posts
    294

    Re: Shortcut in Transposing Rows to Column

    Try the attached

    Sheet 1 has your original data. I named column A sourcedata to make life easier.

    Sheet 2 has a formula in cell A1 which I copied across and down.
    =INDEX(sourcedata,ROW()*10-(10-COLUMN()))
    Once you have this, you can copy > paste special > values if you want to get rid of the formulae.
    Attached Files Attached Files
    Kind Regards,

    Out of the Hat

    "Computers are stupid - they do EXACTLY what you tell them to"

    If I've helped you with a problem, please say thanks by clicking the small star icon on the left.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1