Data sort

  • Thread starter Thread starter dragan7746
  • Start date Start date
D

dragan7746

I have a large number if names, addresses, phone numbers etc that I
imported to a excel sheet off a web site. Now here is the prolem.
Each record is not in a single line. The format is laid out with a1
has the license number, b1 has the status, c1 company name, c2 address,
c3 has th city, state, Zip, d1 has the owner, d2 has phone number, d3
has email (some blank).

Sorting this in its present format I don't think can be done and keep
all info together.

Let me know if you want a page to look at

I am trying to import thins into a contact management program
(Goldmine)
 
Let's assume all this stuff is on Sheet1
We will consolidate all of it in Sheet2 ready for sorting
1)On Sheet2 in A1 enter the text Licence, in B1 Status, C1 Company, D1
Address, E1 City, F1 Owner, G1 Phone, H1 E-mail
2)Move to A2, type =1, click Sheet1 tab and click on A1, Formula bar shows
=Sheet1!A1, click green check mark to OK
3) Copy formula across to C2;
4) In D2 type =, open Sheet1, click on C2, click green check mark, formula
read = Sheet1!C2
5) Copy this across to H1
6) Copy A2:H2 to rows 3 and 4.
7) Select all in row 3 and delete it.
8) Select A2:H4 and drag down to row 2N where N is the number of records in
Sheet1
9) Sort and discard empty rows or use

Hope this helps.
Bernard
 
I tried to use what you wrote, but on the first cell when I entered =1
the formula that you said would be there wasn't. I got it to show up,
sort of, by putting a "!" before the 1. Excel then said there was an
error in the formula.

I attached 1 page of the excel worksheet so you could see it to make
sure I explained it correctly

Thanks

File Attached: http://www.exceltip.com/forum/attachment.php?postid=300416 (sample.xls)
 
Back
Top