Restructuring records into a list
try a pivot table or transpose
" wrote:
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 987
I am trying to make a table from these in the form
ABC DEF GHI
123 456 789
321 654 987
I 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!
Aaron
|