| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a single row to separate data multiple times
How do I insert a row for every change in value for column C?
I need it to separate data Currently I sort the spreadsheet and then scroll thru the entire thing inserting rows for each variable listed in column C. Example: Value in rows 1 thru 5 of column C are 27; and the value in rows 6 thru 8 are 28; rows 9 & 10 are 29 and so on and so on. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using SUBSTITUTE multiple times on single cell of data | Excel Discussion (Misc queries) | |||
| Inserting Data Repeated Times | Excel Discussion (Misc queries) | |||
| Combining data from multiple worksheets and separate spreadsheets | Excel Discussion (Misc queries) | |||
| Displaying single and multiple data series.Single data series | Charts and Charting in Excel | |||
| Multiple dates, times, or formulas in a single cell | Excel Discussion (Misc queries) | |||
Threaded Mode
