Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 18th 06, 09:50 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
Default 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   Report Post  
Old August 18th 06, 10:57 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
Default covert columns into rows


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.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=572984

  #3   Report Post  
Old August 18th 06, 10:34 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default 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" 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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rows & Columns in Excel seadragon69 Excel Worksheet Functions 2 December 7th 05 05:54 PM
convert columns to rows & rows to columns ROCKWARRIOR Excel Discussion (Misc queries) 2 September 23rd 05 06:31 PM
How to swap rows and columns? [email protected] Excel Discussion (Misc queries) 5 September 21st 05 08:07 AM
hidden rows & columns slow file open Simon Shaw Excel Discussion (Misc queries) 0 April 5th 05 12:21 AM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM


All times are GMT +1. The time now is 02:43 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017