+ Reply to Thread
Results 1 to 3 of 3

Copy Info between Cells and Sort by Horizontal Titles

  1. 05-25-2014, 10:56 AM #1
    awolfa
    awolfa is offline
    Registered User
    Join Date
    03-01-2014
    Location
    Okemos, MI
    MS-Off Ver
    Excel 2010
    Posts
    8

    Copy Info between Cells and Sort by Horizontal Titles

    I have a column of Data (A1:A20584) that includes information for different contacts

    BEGIN
    VERSION
    N
    FN
    TEL
    TEL
    EMAIL
    ADR
    ADR
    ORG
    END

    I need the information to list as Row Titles (horizontally) so I can sort. I hope I am saying this correctly.

    Can someone assist with this request?

    Kind Regards,
    Ami
    Reply With QuoteRegister To Reply
  2. 05-25-2014, 11:06 AM #2
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Copy Info between Cells and Sort by Horizontal Titles

    Hi,

    Welcome to the forum

    I do not understand your request?
    In Excel, you can transpose a column of data into a row by using Copy and Paste Special, but even with the latest version of Excel, you only have just over 16000 columns. That data will not fit into columns. Secondly, sorting is easier to perform by column anyways?

    Could you upload a sample file with a small amount of data that illustrates a before and after to clarify what you need.

    TX
    Regards,
    Rudi
    Reply With QuoteRegister To Reply
  3. 05-29-2014, 09:08 AM #3
    awolfa
    awolfa is offline
    Registered User
    Join Date
    03-01-2014
    Location
    Okemos, MI
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Copy Info between Cells and Sort by Horizontal Titles

    I am going to cancel a request to help as I think this is more of an if statement and will repost my question.
    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)

Similar Threads

  1. Ignore empty cells when doing horizontal sort with VBA
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2012, 09:01 PM
  2. Horizontal Titles on Print pages
    By mbruce3 in forum Excel General
    Replies: 1
    Last Post: 09-20-2011, 06:07 PM
  3. Formatting Horizontal Axis Titles
    By lindsayboxer in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-30-2011, 05:31 AM
  4. Search for info and copy found info to specific cells
    By Costas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2010, 07:12 AM
  5. Use horizontal column titles in list box (VBA form)
    By Mr. Smith in forum Excel General
    Replies: 5
    Last Post: 07-10-2006, 06:09 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1