Arranging continuous text into rows and columns

I receive a data file "input" sheet in the attached file. I have to convert this into as in the "output" sheet. Is there any coding for this.

Your result looks strange to me, or am I missing something?

Please Login or Register  to view this content.

Greetings,
Perfect solution. You have not missed anything. What I require was to separate the attribute value ( #) from the asset (Transformers) and the place (station).

Thanks
Rajesh