"Bald Eagle" <cre### [at] netscapenet> wrote:

> I see what I can do, unless you beat me to it  ;)

It took me a while to struggle with some of the syntax in LibreOffice, and
puzzle out how to pair INDIRECT() with ADDRESS() so I could specify a cell
range, but I think it should work.
Just needs a minor tweak to make it fully automated (hopefully I'll do that
tomorrow)

Your sample data set gets transformed into and array made of 400 other arrays,
the largest of which has 36 elements.

I sent you an email.  :)

Post a reply to this message