Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |