Help me with a pdf converted into excel

[Martha]

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

Name: Abend, Nicholas
E-Mail Address: (e-mail address removed)
Office Phone Number: 4-1710
Department: Neurology


Name: Adelekan, Tahira
E-Mail Address: (e-mail address removed)
Office Phone Number:
Department: Developmental and Behavioral Pediatrics


Name: Ades, Anne
E-Mail Address: (e-mail address removed)
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.

 

[Richard]

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
(e-mail address removed)

Hope this helps,

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

Name: Abend, Nicholas
E-Mail Address: (e-mail address removed)
Office Phone Number: 4-1710
Department: Neurology

Name: Adelekan, Tahira
E-Mail Address: (e-mail address removed)
Office Phone Number:
Department: Developmental and Behavioral Pediatrics

Name: Ades, Anne
E-Mail Address: (e-mail address removed)
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

 

[Martha]

Richard,
Thanks for the assistance. I have been able to do everything below but i am
having a problem with the vlookup formula. I keep getting a 'value not
available' error. Let me know what to do next. Thiis is great!Thanks a
million.