software

Hello,

I currently have a long series of records in the structure

Descriptor Value
ABC 123
DEF 456
GHI 789

ABC 321
DEF 654
GHI 987I am trying to make a table from these in the form

ABC DEF GHI
123 456 789
321 654 987I thought I had it made with an OFFSET function, but I have the problem
that some records have multiple lines of the same descriptor and some
records have blank rows. For example, one record may have the form

ABC 123
DEF 234
DEF 345
GHI 987

or

ABC 123
DEF 234

GHI 987

But in every case the records start and end with the same descriptor.

I'm guessing this is best done in a multistep method to combine the
multiple rows (make a DEF 234345) and eliminate the balnk rows, but I
am not making any progress.

I've learned a lot from this group and really hope someone out there
has some suggestions....

Thanks!

Aarontry a pivot table or transpose

quot; wrote:

gt; Hello,
gt;
gt; I currently have a long series of records in the structure
gt;
gt; Descriptor Value
gt; ABC 123
gt; DEF 456
gt; GHI 789
gt;
gt; ABC 321
gt; DEF 654
gt; GHI 987
gt;
gt;
gt; I am trying to make a table from these in the form
gt;
gt; ABC DEF GHI
gt; 123 456 789
gt; 321 654 987
gt;
gt;
gt; I thought I had it made with an OFFSET function, but I have the problem
gt; that some records have multiple lines of the same descriptor and some
gt; records have blank rows. For example, one record may have the form
gt;
gt; ABC 123
gt; DEF 234
gt; DEF 345
gt; GHI 987
gt;
gt; or
gt;
gt; ABC 123
gt; DEF 234
gt;
gt; GHI 987
gt;
gt; But in every case the records start and end with the same descriptor.
gt;
gt; I'm guessing this is best done in a multistep method to combine the
gt; multiple rows (make a DEF 234345) and eliminate the balnk rows, but I
gt; am not making any progress.
gt;
gt; I've learned a lot from this group and really hope someone out there
gt; has some suggestions....
gt;
gt; Thanks!
gt;
gt; Aaron
gt;
gt;

add heading to your data and:
add one more column an put there formula:
count.if($B$2:B2;B2)
paste it down
then create pivot table
should work
mcg