Hi,

Simplest way is as follows.

1. Copy your data as below and paste into B2. This will result in a
single column of data. 2. Now select column B and from the menu choose
-- Data, Text to Columns, select the Delimited option button, then
Next and in the Other Box enter the colon ':' symbol, then Next and
choose the 'Text option and then Finish.

You should now have all your data in two columns with the field
headings in column B and the variable data in column B.

3. Now copy your 4 field headings into E1:H1
4. put the following formula in A2 and copy down
=INT(ROW()/6+1)&B2
This will create a unique ID for each row, comprising the 1st, 2nd
3rd, etc block of data plus the field name. Note the divisor 6 would
need to be altered if there were more or less than two blank rows
between each set of data.

5. Put the following formula in E2
=VLOOKUP(ROW()-1&E$1,$A:$C,3,FALSE)
and copy this across to H2 and down as many rows as you have sets of
data.

All your data should now be lined up in columns E:H w

If you have any problems and want to send me the file, email it to


Hope this helps,






In article
wrote:



i have converted a file from PDF ro excel and it looks like this:

Name: Abend, Nicholas
E-Mail Address:
Office Phone Number: 4-1710
Department: Neurology

Name: Adelekan, Tahira
E-Mail Address:
Office Phone Number:
Department: Developmental and Behavioral Pediatrics

Name: Ades, Anne
E-Mail Address:
Office Phone Number:
Department: Neonatology

How do i make the name, email address, office number and department
be headings and all the other information to drop in the correct
sections as the mentioned titles? Also when i converted it, all the
information appears in one column. Please help me. I can email the
spreadsheet to anyone willing to help and they can walk me through if
they want.

***
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at http://www.malcom-mac.com/nemo