If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
generate multiple rows based on cell value
Hi,
I have a worksheet where I would like to generate multiple rows based on a cell value (ex. "4" would give me 4 rows, each with a value of 1 in a column). So it's not a transpose, since I don't want the value 4 to be converted from a column to a row. Instead I want a value to be split into multiple cells. More specifically: Start with: Column A heading= Site, Column B heading= Spruce, Column C heading = Aspen. Value in column A = 1, Value in column B = 4 (a count, # of trees), Value in column C = 2 (a count, # trees). End with: Column A Heading = Site, Column B heading = Species, Column C heading = Number. Will have 6 rows with value in Column A (site)= 1; 4 of these will say 'spruce' in column B, 2 will say 'aspen' in column B, and all values in Column C will be 1. Any help would be greatly appreciated. Thanks in advance, Theresa |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to compare multiple rows values based on another column? | Murph | Worksheet Functions | 4 | February 21st, 2005 02:44 AM |
Office 2003 installation problem, log file attached.... | Ryan | Setup, Installing & Configuration | 0 | January 20th, 2005 06:57 PM |
Inserting multiple rows into a table while maintaining data? | JAnderson | General Discussion | 2 | July 8th, 2004 05:45 PM |