sharon christa wrote:Some please tell me how to do it.
'Fraid we'll need an awful lot more information than that.
What do you mean by a 'dataset'?
Where does it come from? If a database, then almost certainly operation #4 (and probably #2 as well) should be done in the database, because that's what they were designed for.
What do you mean by 'splitting' columns and rows?
Isn't it funny how there's always time and money enough to do it WRONG?