Hello,

I am trying to read a text file with data(+headers) with the following
format.

X
12.1
23.
43
54
..
..
..
Y
5
76
87
34
23
..
..
X
..
..
..
Y
..
..
..

I want to rearrange it into two columns X and Y. How do I do that. I
want to write en excel macro. Please help. Thanks

Srikanth