Creating Pivot from phone list

[cougarclg]

HI,

I do not know Why I'm struggling so much with this simple thing.
I'm using Excel 2013 and I want to create a contact list in a correct format to load on my phone.

the Raw data looks like this:
[TABLE="width: 298"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Column1[/TD]
[TD]Column2[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]NAME[/TD]
[TD] 3g [/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]MOB[/TD]
[TD]8444444[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]NAME[/TD]
[TD] 3g (MTN) [/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]MOB[/TD]
[TD]8222222[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]NAME[/TD]
[TD] AAAAAAAAAA [/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]MOB[/TD]
[TD]82222222[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]NAME[/TD]
[TD] Aandklas [/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD]MOB[/TD]
[TD]1223333[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]ADDR[/TD]
[TD];Cape Town;Western Cape;;South Africa[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]NAME[/TD]
[TD] Adrian (van George) [/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD]MOB[/TD]
[TD]9322222

[/TD]
[/TR]
</tbody>[/TABLE]


BUT ITS SUPPOSE TO LOOK LIKE THIS:
[TABLE="width: 324"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]NAME[/TD]
[TD]MOB[/TD]
[TD]ADDR[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD] 3g [/TD]
[TD]8444444[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD] 3g (MTN) [/TD]
[TD]8222222[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD] AAAAAAAAAA [/TD]
[TD]82222222[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD] Aandklas [/TD]
[TD]1223333[/TD]
[TD];Cape Town;Western Cape;;South Africa[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD] Adrian (van George) [/TD]
[TD]9322222[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I would really like some assistance. i have been wasting alot of precious time to solve this.

Thank you,
CLG