Good afternoon,
I have a data distributed as shown by table 1 from cell A1: all the data in three rows, each two columns are one calendar year information ( suppose the data spread until the last column). How can cut and paste it into two columns as shown by table 2 from cell A1? Code maybe the only solutions. Right now I just give up my manual cut and paste as I have the data until the last column.
Thanks lot.
Dennis
Table 1
2003 1 2002 3 2001 5
2004 2 2003 4 2002 6
2005 3 2004 5 2003 7
table 2
2003 1
2004 2
2005 3
2002 3
2003 4
2004 5
2001 5
2002 6
2003 7
I have a data distributed as shown by table 1 from cell A1: all the data in three rows, each two columns are one calendar year information ( suppose the data spread until the last column). How can cut and paste it into two columns as shown by table 2 from cell A1? Code maybe the only solutions. Right now I just give up my manual cut and paste as I have the data until the last column.
Thanks lot.
Dennis
Table 1
2003 1 2002 3 2001 5
2004 2 2003 4 2002 6
2005 3 2004 5 2003 7
table 2
2003 1
2004 2
2005 3
2002 3
2003 4
2004 5
2001 5
2002 6
2003 7