Transpose Columns to Rows (automatically inserts new rows)

Hi, I am new here and complete amazed how macro's can make life so much easier but I just can't seem to understand the codes (no programming knowledge).

I would like to have the sports column to be transposed as rows. I have provided a sample file below.

I can do the job manually by
1. Adjust the other columns (C D E) to about 20 columns away.
2. Use data to columns (delimited by ";").
3. Insert 20 additional rows in between the existing rows.
4. Copy the sports.
5. Special Paste> Transpose.
6. Move on to the next item and repeat 1-5.
7. After finishing, I just use ASAP Utilities to delete the empty rows.

The thing is my file is composed of almost 20k entries and repeating the process would take time.
Can anyone help me with this matter?
It will be surely appreciated. Thank you.