How to sort and assign unique id for data in rows in excel

[dj123]

Dear All,
I have large amount of data to sort and to assign id for database bulk upload. It is really hard to manually assign its own id for each data. So if anybody knows ,can you please tell me how to do this in excel.
The data is shown as below

[TABLE="width: 1199"]
<tbody>[TR]
[TD]City[/TD]
[TD]State[/TD]
[TD]email[/TD]
[TD]website[/TD]
[TD]landphone[/TD]
[TD]country[/TD]
[TD]skype id[/TD]
[TD]Mobile number[/TD]
[TD]Business description[/TD]
[TD]Products/Service[/TD]
[TD]District[/TD]
[TD]Pincode[/TD]
[TD="colspan: 3"]Monday working hours[/TD]
[/TR]
[TR]
[TD]Kottayam[/TD]
[TD]Kerala[/TD]
[TD]M@ek.com[/TD]
[TD]manoj.com[/TD]
[TD="align: right"]123456[/TD]
[TD]India[/TD]
[TD]mano.m[/TD]
[TD="align: right"]839030227[/TD]
[TD]IT services[/TD]
[TD]Software[/TD]
[TD]kottayam[/TD]
[TD="align: right"]23434[/TD]
[TD="colspan: 2"]8.00-17.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Kottayam[/TD]
[TD]Kerala[/TD]
[TD]V@ek.com[/TD]
[TD]Varkey.com[/TD]
[TD="align: right"]234234[/TD]
[TD]India[/TD]
[TD]varkey.v[/TD]
[TD="align: right"]332642300[/TD]
[TD]Financial Consulting[/TD]
[TD]Mortgage[/TD]
[TD]kottayam[/TD]
[TD="align: right"]54554[/TD]
[TD="colspan: 2"]8.00-17.01[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Perintalmanna[/TD]
[TD]Kerala[/TD]
[TD]K@ek.com[/TD]
[TD]Kurup.com[/TD]
[TD="align: right"]24242[/TD]
[TD]India[/TD]
[TD]kurup.v[/TD]
[TD="align: right"]563873922[/TD]
[TD]Agricultural sector[/TD]
[TD]Tools and machineries[/TD]
[TD]perintalmanna[/TD]
[TD="align: right"]34452[/TD]
[TD="colspan: 2"]8.00-17.02[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Calicut[/TD]
[TD]Kerala[/TD]
[TD]Ku@ek.com[/TD]
[TD]Kuttan.com[/TD]
[TD="align: right"]6767568[/TD]
[TD]India[/TD]
[TD]kuttan.k[/TD]
[TD="align: right"]933730304[/TD]
[TD]Banking[/TD]
[TD]Finance, saving[/TD]
[TD]caicut[/TD]
[TD="align: right"]12234[/TD]
[TD="colspan: 2"]8.00-17.03[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

It has to be like
[TABLE="width: 216"]
<tbody>[TR]
[TD]Field id[/TD]
[TD]Field Value[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD] Manoj[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD] Pala[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Kottayam[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]Kerala[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]M@ek.com[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]manoj.com[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]123456[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]India[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]mano.m[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD="align: right"]839030227[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]IT services[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD]Software[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD]kottayam[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]23434[/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD] 8.00-17.00[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Varkey[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Ktym[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Kottayam[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]Kerala[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]V@ek.com[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]Varkey.com[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]234234[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]India[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]varkey.v[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD="align: right"]332642300[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]Financial Consulting[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD]Mortgage[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD]kottayam[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]54554[/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD]8.00-17.01[/TD]
[/TR]
</tbody>[/TABLE]
Field Id's are

fieldid
1: contact person
2: locality
3:City
4:State
5:email
6:website
7:land phone
10: country
11:Contact Person skype id
19: mobile
20: business description
21: product/ service
22: District
23: Pin
25 : monday working time
26: T working time
27: w working time
28: th working time
29: fr working time
30: sat working time
31: sun working time

It would have been a very big help if someone can help me in doing the same.
Thanks in Advance
Joe

 

[svendiamond]

Just copy the first row, and when you right click to paste in a new location, click on paste special "Transpose" - then do the same with the other rows.

 

[dj123]

Thanks for the quick response. Not like that .it has to assign unique field id as well. after the first set of data the second one should follow the first one with unique id.
Thanks for your time.

 

[svendiamond]

Right... so copy row A and paste onto a new column that doesn't have anything in it. Then do the same with each row.

For example, copy A1:A100 and paste in onto a new sheet in cell A1. Then copy B1:B100 and paste into new sheet B1.

 

[svendiamond]

Or... are you saying you just want column A and B? Why does your result only go 1-25? Sorry I don't think I understand what exactly you need the results to look like.

 

[dj123]

Dear Svendiamond , Thanks for your answer. I think my question is not explained properly. And when i copy pasted some parts of it are missing. You see the first part of data , ie the date to be sorted. That data has to be sorted column wise according to the unique field id ( end of my question). The output file must only have 2 columns ie unique id and the corresponding data as you see it in my question. Here is the drop box files. Please check it if possible. The video is in another language, but you can see the files. https://www.dropbox.com/sh/hhrx8j34ilee4k1/AABhizYD0xtAydWqjBXyXgGGa?dl=0 . Thanks again for the time.
Joe