Posted: 3/26/2003 9:10:12 AM EDT
|
I have a table in Microsoft Excel that looks like this: [b] 10 20 30 40 50 [/b] [b] a [/b] 1.1 1.5 1.3 1.4 2.2 [b] b [/b] 3.1 2.4 5.4 6.1 0.5 [b] c [/b] 1.1 3.5 1.3 6.1 0.5 [b] d [/b] 4.1 9.5 5.3 7.4 2.2 [b] e [/b] 5.1 1.5 9.3 8.4 2.2 a,b,c,d,e are the rownames and 10, 20 , 30, 40 ,50 are the column names I need to turn this table into a flat text file with one line per number, so it would look like this: a 10 1.1 a 20 1.5 a 30 1.3 a 40 1.4 a 50 2.2 b 10 3.1 b 20 2.4 . . . e 40 8.4 e 50 2.2 Can anyone suggest a good way to automate this in excel or access that will work with tables of varying numbers of rows and columns? |