Hi
I have 1281 excel files that all contain one type of data in the first cell =A1.
The excel files are named Error_a_100514_01.cv ...to...Error_a_100514_10 and then Error_a_120414_01 ..to...Error_a_120414_10 and so on, repeated to 32 x 10, x 4 ('a'..'d')
I would like to read '100514' as a row title and for each row take values from 01 to 10 in different coloumns.
Please help - I want to output this quickly.
0 Comments
Sign in to comment.