I have a data range for product output for 2001,2002...as follows :
product 2001 2002
a 10 20
b 30 40
..
I want to rearrange the data by putting all years in one column as follows :
product
a 10 2001
b 30 2001
a 20 2002
b 40 2002
..
Yes, I can do that by using cut and paste method. But it really takes ime if
the number of years in the above example is not limited to 2 but 10 or 20 or
more
..
My question is : How can I rearrange data as above by using another method
that is faster instead of using cut and paste method
..
thanks a lot