Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Row between items in list ...
Hi ...
I have an Excel sheet with 5,000 names in one column. Is there any fast way to insert a row after every name so the names appear on every other row (i.e, list will then occupy 10,000 rows, one empty row after each name)? I can do this with a macro, but wanted to make sure there wasn't a simple function or other Excel feature that is designed to do this. Thanks for your help ... bill |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Row between items in list ...
bill,
Use a blank adjacent column. Fill in sequential numbers using 1 thru 5000 in the column. Fill in another sequential list of 5000 numbers directly below (in the same column) using... 1.1, 2.1 thru 5000.1. Select the data and the new column then sort using the new column as the sort column. Clear the numbered column. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "WCM" wrote in message Hi ... I have an Excel sheet with 5,000 names in one column. Is there any fast way to insert a row after every name so the names appear on every other row (i.e, list will then occupy 10,000 rows, one empty row after each name)? I can do this with a macro, but wanted to make sure there wasn't a simple function or other Excel feature that is designed to do this. Thanks for your help ... bill |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Row between items in list ...
Hi Jim,
Very creative! Perfect, simple solution. Thank you...! b. "Jim Cone" wrote: bill, Use a blank adjacent column. Fill in sequential numbers using 1 thru 5000 in the column. Fill in another sequential list of 5000 numbers directly below (in the same column) using... 1.1, 2.1 thru 5000.1. Select the data and the new column then sort using the new column as the sort column. Clear the numbered column. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "WCM" wrote in message Hi ... I have an Excel sheet with 5,000 names in one column. Is there any fast way to insert a row after every name so the names appear on every other row (i.e, list will then occupy 10,000 rows, one empty row after each name)? I can do this with a macro, but wanted to make sure there wasn't a simple function or other Excel feature that is designed to do this. Thanks for your help ... bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching items in 2 list to consolidate to one list | Excel Discussion (Misc queries) | |||
Items on Insert ribbin on excell 2007 are grayed out. Why? | Excel Discussion (Misc queries) | |||
How do I delete items in one list from another list? | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
sum particular items from a list | Excel Discussion (Misc queries) |