LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posts: n/a
Default generate multiple rows based on cell value


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 =
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,

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
Format cell in column B based on value in the next cell (column c) Nicole Excel Discussion (Misc queries) 7 May 18th 05 10:19 PM
Counting rows based on criteria in multiple cells Margaret Excel Discussion (Misc queries) 11 December 3rd 04 12:04 AM
Returning a Value to a Cell Based on a Range of Uncertain Size amc422 Excel Worksheet Functions 7 November 14th 04 04:03 PM
parse cell and insert rows? Gorrila Grod Excel Worksheet Functions 3 November 5th 04 09:19 AM
Modify Row based upon cell value Brett Patterson Excel Worksheet Functions 0 November 5th 04 12:09 AM

All times are GMT +1. The time now is 12:20 AM.

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

About Us

"It's about Microsoft Excel"