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

City

State

email

website

landphone

country

skype id

Mobile number

Business description

Products/Service

District

Pincode

Monday working hours

Kottayam

Kerala

M@ek.com

manoj.com

123456

India

mano.m

839030227

IT services

Software

kottayam

23434

8.00-17.00

Kottayam

Kerala

V@ek.com

Varkey.com

234234

India

varkey.v

332642300

Financial Consulting

Mortgage

kottayam

54554

8.00-17.01

Perintalmanna

Kerala

K@ek.com

Kurup.com

24242

India

kurup.v

563873922

Agricultural sector

Tools and machineries

perintalmanna

34452

8.00-17.02

Calicut

Kerala

Ku@ek.com

Kuttan.com

6767568

India

kuttan.k

933730304

Banking

Finance, saving

caicut

12234

8.00-17.03

<tbody>
</tbody>

It has to be like

Field id	Field Value
1	Manoj
2	Pala
3	Kottayam
4	Kerala
5	M@ek.com
6	manoj.com
7	123456
10	India
11	mano.m
19	839030227
20	IT services
21	Software
22	kottayam
23	23434
25	8.00-17.00
1	Varkey
2	Ktym
3	Kottayam
4	Kerala
5	V@ek.com
6	Varkey.com
7	234234
10	India
11	varkey.v
19	332642300
20	Financial Consulting
21	Mortgage
22	kottayam
23	54554
25	8.00-17.01

<tbody>
</tbody>

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