Hi everyone! Does anyone know an excel macro that would enable me to put
row data into a single column? I basically have quarterly data for 5
years with each row containing the quarterly data for each year (row).
I just want to make the data into a time series. So it's something
like: (ignore the dots)


Year ...... Q1 ....... Q2 ....... Q3 ....... Q4
1990 ...... 2 ......... 5 ......... 3 ......... 9
1991 ...... 8 ......... 1 ......... 4 ......... 6

and I want a macro that would put the row data into a single column so
that it would look like:

2
5
3
9
8
1
4
6

Any assistance would be greatly appreciated. Thanks!


--
uberathlete
------------------------------------------------------------------------
uberathlete's Profile: http://www.excelforum.com/member.php...o&userid=28388
View this thread: http://www.excelforum.com/showthread...hreadid=531174