I have been given heaps of maintenance plans which i need to extract the
information from. they are currently set out like the following;
With the asset on the side, days on the top and letters in the middle which
represent the maintainence task.


DAYS
1 2 3 4 5 6 7
Asset 1 D
Asset 2 F
Asset 3 D
Asset 4 D
Asset 5
Asset 6 E
Asset 7 E


I want to be able to quickly format, run a macro, or code to get this
information into the following format.

Task Day
Asset 1 D 1
Asset 4 D 2
Asset 7 E 2
Asset 2 F 3
Asset 6 E 6
Asset 3 D 7


Any help on this would be great.

Cheers Peter