Transpose words and numbers into array of different proportions
Maybe you guys could take a break from giving free technical school
answers to lazy partiers and try this fun problem. I dreamed part of
it last nicht.
How do I transpose an array of words and numbers into an array of
different proportions?
The proportions of the arrays can be anything, including n x 1 and 1 x
n.
The size of the array can be anything that fits on a worksheet and can
be located anywhere on the worksheet.
Ex:
Array of the present (4x5)
ab 12 de 1.55 ghe
ef 34 nu 3.65 unt
gh 56 mc 2.45 wen
kl 78 vm 1.35 rep
After a re-arrange (7x3)
ab 12 de 1.55 ghe ef 34
nu 3.65 unt gh 56 mc 2.45
wen kl 78 vm 1.35 rep
I am uncomfortable with VBA so don't use VBA.
I don't want to copy/paste because I want the second array to update
immediately when I change the values in the first array.
Also another reason I don't want to use VBA is I would necessitate to
run it after every update.
Thank you and have a good evening,
Manfred Straub
(originally from east Zurich)
|