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.

hi kichkichkich, welcome to ExcelForum, please check attachment, run code "test"

PS. I'm not sure I understand 7th step, what empty rows are deleted

Originally Posted by watersev

hi kichkichkich, welcome to ExcelForum, please check attachment, run code "test"

PS. I'm not sure I understand 7th step, what empty rows are deleted

wow! this is great! Thank you for your help <3

if you notice there are two codes there: one with formating as in output sheet and one without (blocks without thick border around)

Yes I have seen it and thank you, grrr I badly need to know how to use these codes
Thanks again .

Hi, Sorry but this is the first forum which I posted this question so I wasn't able to link the other forums.
As a response, here are the other links
http://www.mrexcel.com/forum/showthr...=1#post3135443
http://www.ozgrid.com/forum/showthre...446#post606446

Thank you

Originally Posted by jeffreybrown

Well with three choices to pick from now you got some learning ahead

Yes sir