|
I love Excel.
That said, for those cases I usually do some kind of labelling. I create an intermediate table that contains the rearrangement instructions (like a label for each data position) and then I create formulas in the final table that populate it with the data from table 1 using the instructions from table 2. This way it is easier to troubleshoot.
If you can share your problem I'd love to give it a go.
|