+ Reply to Thread
Results 1 to 3 of 3

Horizontal to Vertical

  1. #1
    Registered User
    Join Date
    10-04-2007
    Posts
    2

    Horizontal to Vertical

    I have three columns of data formatted on the sheet horizontally but I need to use that data on a different sheet, vertically. Is there an quick way to change from horizontal to verical and vice versa? Thanks! Jett

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Transpose I suppose....

    Copy the data and then paste it with

    Edit >Paste Special > tick "Transpose"

  3. #3
    Registered User
    Join Date
    10-04-2007
    Posts
    2
    Perfect! Thanks!

+ 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