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

dj123

New Member
Joined
Dec 19, 2014
Messages
4
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

CityStateemailwebsitelandphonecountryskype idMobile numberBusiness descriptionProducts/ServiceDistrictPincodeMonday working hours
KottayamKeralaM@ek.commanoj.com123456Indiamano.m839030227IT servicesSoftwarekottayam234348.00-17.00
KottayamKeralaV@ek.comVarkey.com234234Indiavarkey.v332642300Financial ConsultingMortgagekottayam545548.00-17.01
PerintalmannaKeralaK@ek.comKurup.com24242Indiakurup.v563873922Agricultural sectorTools and machineriesperintalmanna344528.00-17.02
CalicutKeralaKu@ek.comKuttan.com6767568Indiakuttan.k933730304BankingFinance, savingcaicut122348.00-17.03

<tbody>
</tbody>

It has to be like
Field idField Value
1 Manoj
2 Pala
3Kottayam
4Kerala
5M@ek.com
6manoj.com
7123456
10India
11mano.m
19839030227
20IT services
21Software
22kottayam
2323434
25 8.00-17.00
1Varkey
2Ktym
3Kottayam
4Kerala
5V@ek.com
6Varkey.com
7234234
10India
11varkey.v
19332642300
20Financial Consulting
21Mortgage
22kottayam
2354554
258.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
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

svendiamond

Well-known Member
Joined
Jun 13, 2014
Messages
1,498
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Dec 19, 2014
Messages
4
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

Well-known Member
Joined
Jun 13, 2014
Messages
1,498
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Jun 13, 2014
Messages
1,498
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Dec 19, 2014
Messages
4
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,471
Messages
5,596,350
Members
414,060
Latest member
hermanseck

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top