How can I transpose?

Hi,  I have a clue. I have such a file Avril Wednesday Thursday Friday Antoine LCI RTT    Philippe L 4 D 4 L 4 Alan CV L 4 R Francis D 6 D 6 D 6   I'd like to tr...