RE: Duplicate rows into new rows based on row value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

That's right I am looking to expand the data. Referencing the above example
the spreadsheet has say two rows. I need a solution that takes these two
rows and breaks them into 5 rows (according to the value in column a). So
the first row (2 ABC) will eventually be two individual rows because of the
value in column a and the second row will be changed into 3 rows. I almost
think of it as a reverse subtotal. I hope this clarifies things.
Thanks in advance!


"Wehrmacher" wrote:

I am not sure I understand the question. It looks like the example is a
sorting of a long list of rows that contain similar identical data in some
fields. If this is what you are looking for, you can look in the Data menu,
select Sort and chose the column priorities and orders you wish.

You may also want to take a look at Pivot Tables. These things organize your
data according to the content of row and column information. I doubt this is
what you are talking about as pivot tables are used to compress data and your
question seems to talk about expanding it.

Hope this helps.
--
Bill Wehrmacher


"Tom" wrote:

Hi,
I am trying to breakout multiple rows into individual rows based on a value
in the row.... sounds confusing. Here's an example
a b c etc....
1 2 ABC 5.5
2 3 DEF 2.3

I need to break this out into individual rows like this...

a b c
1 2 ABC 5.5
2 2 ABC 5.5
3 3 DEF 2.3
4 3 DEF 2.3
5 3 DEF 2.3

Is this possible using a function or macro? Please let me know.

Thanks in advance!


.

Relevant Pages

  • RE: Duplicate rows into new rows based on row value
    ... You may also want to take a look at Pivot Tables. ... 2 ABC 5.5 ... I need to break this out into individual rows like this... ... 3 DEF 2.3 ...
    (microsoft.public.excel.worksheet.functions)
  • Duplicate rows into new rows based on row value
    ... sounds confusing. ... 2 ABC 5.5 ... I need to break this out into individual rows like this... ... 3 DEF 2.3 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: A subquery? Not sure if this is doable?
    ... the weekly series and the repeating monthly figure. ... 1/12/05 ABC 4.22 ... 1/12/05 DEF 3.12 ... 1/12/05 XYZ 8.88 ...
    (microsoft.public.access.queries)
  • Re: Classes as units of reuse
    ... Component ABC { ... The thing that is not clear in your pseudo code is the nature of the relationship between ABC and DEF. ... IMO, the second approach would be the best where one abstracts some set of objects with the proper functionality and then decouples their details from the rest of the application via a Facade interface to which the clients all talk. ... In the OO paradigm one basically has three levels of logical indivisibility: subsystem, object, and responsibility. ...
    (comp.object)
  • Re: A subquery? Not sure if this is doable?
    ... frequency such that the table with less frequency will repeat its value ... 1/12/05 ABC 4.22 ... 1/12/05 DEF 3.12 ... 1/12/05 XYZ 8.88 ...
    (microsoft.public.access.queries)