Prev: How to load specific range of data from html into excel?
Next: how do I create a macro to select all colored cells in a worksheet
From: KIM W on 1 Feb 2010 13:03
Thanks to all! I will be applying and adapting these in the next couple of
days.

"KIM W" wrote:

> Don't hesitated to say this is too much for a forum question....
>
> I am attempting to place a series of values from a column into rows, but the
> details of this task are much more than typical transpose. I have played
> with formulas, MATCH, OFFSET, etc. and got tangled up. That still my be good
> way to go.
>
> Here bleow is DATA is in COL A and B. Output starts in COL C and continues
> across as many columns as needed. When values repeat in A, transpose the
> values from COL B for that repeated COL A value starting at COL C through
> possibly 100 columns, i.e. COL A value could repeat 100 times. It is
> important to note that in a grouping of repeaded rows (defined by repeating
> value in COL A), the resulting transposed values from COL B repeat down for
> each repeated row. This is why all the rows of data for the f's are the
> same-- this is intentional. In other words, transpose all the values in COL
> B for a group of repeating values in A, and transpose across the row
> containing first value of COL A, the fill down identically for all COL A
> group.
> Why am I attempting this? It is to identify identical groupings of values,
> e.g. somewhere else in the list there will be another group of rows, say 4
> rows with "z" in COl A, and those four rows have the same values as found in
> COL B, therefore one can say group f and group z are identical-- a list of
> identical groups is the objective. There may be several identical
> groupings, not just two. ALternatives are welcome. (In my soloution I expect
> to concatenate the values in COL C... and sort on that concatenation, then
> subtotal/count.)
> COL A COLB COL C COL D COL E COL F COL G
> a kk kk
> b mm mm
> c mm mm
> d nn nn pp
> d pp nn pp
> e qq qq
> f rr rr ss tt uu
> f ss rr ss tt uu
> f tt rr ss tt uu
> f uu rr ss tt uu
> g xx
From: Herbert Seidenberg on 2 Feb 2010 11:38
Excel 2007, Table
Count unique repeated row sequences.
Added Rick's great macro for your convenience.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/01_31_10a.xlsm
From: Rick Rothstein on 2 Feb 2010 13:09
Thank you for you very nice compliment... I appreciated it very much.

--
Rick (MVP - Excel)


"Herbert Seidenberg" <herbds7-msxls(a)yahoo.com> wrote in message
news:b067684c-69d5-48f9-b9c6-06ac2ae29754(a)f17g2000prh.googlegroups.com...
> Excel 2007, Table
> Count unique repeated row sequences.
> Added Rick's great macro for your convenience.
> http://c0444202.cdn.cloudfiles.rackspacecloud.com/01_31_10a.xlsm

First  |  Prev  | 
Pages: 1 2
Prev: How to load specific range of data from html into excel?
Next: how do I create a macro to select all colored cells in a worksheet