Help me with a pdf converted into excel

  • Thread starter Thread starter Martha
  • Start date Start date
M

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.
 
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:
Click to expand...
Name: Abend, Nicholas
E-Mail Address: (e-mail address removed)
Office Phone Number: 4-1710
Department: Neurology
Click to expand...
Name: Adelekan, Tahira
E-Mail Address: (e-mail address removed)
Office Phone Number:
Department: Developmental and Behavioral Pediatrics
Click to expand...
Name: Ades, Anne
E-Mail Address: (e-mail address removed)
Office Phone Number:
Department: Neonatology
Click to expand...
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.
Click to expand...

­­ 
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at http://www.malcom-mac.com/nemo
 
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.
 
Back
Top