+ Reply to Thread
Results 1 to 3 of 3

covert columns into rows

  1. #1
    balsrin
    Guest

    covert columns into rows

    Hello,
    I have 19,000 cells of coulmn data in my notepad.I want to
    copy this in a row format in excel.I cannot copy and paste and then
    transpose it becuase excel accepts only 256 coulmns of data. Please
    help!!!

    Sri.


  2. #2
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    break it up into blocks of 200 columns, and edit copy edit paste special transpose each one in turn. This will work if no column is more than 250 rows deep. If that is the case, you will need to make multiple sheets.

  3. #3
    Gord Dibben
    Guest

    Re: covert columns into rows

    How many columns do you currently have?


    Gord Dibben MS Excel MVP

    On 18 Aug 2006 01:50:28 -0700, "balsrin" <balsrin@gmail.com> wrote:

    >Hello,
    > I have 19,000 cells of coulmn data in my notepad.I want to
    >copy this in a row format in excel.I cannot copy and paste and then
    >transpose it becuase excel accepts only 256 coulmns of data. Please
    >help!!!
    >
    >Sri.



+ 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