[libreoffice-users] How to check rows for to replace a value for another in Calc?

Hi again!

I have a problem in Calc. I get a lot of spreadsheets from various 
sources and I have to compile one big sheet with the information of 
every one of them. One of the problems I am facing is that there is a 
lot of names for the same user. So, for example:

PHONE EXTENSION    Name Sheet A
111                                John Doe

PHONE EXTENSION    Name Sheet B
111                                Jon Doe

PHONE EXTENSION    Name Sheet C
111                                J. Doe

Right now, I have kind of a table relating one to another but it is 
absolutely atrocious:

EXT.        Name A        Name B
111        John Doe       J. Doe
111        John Doe        Jon Doe

I would like a system where I could have only one row for person:

EXT.    Name A            Name B    Name C    Name D
111    John Doe            J. Doe    Jon Doe    ...
112    Dorian Gray    D. Gray    Don Gray    ...


And once the table is properly established, I would want to replace 
every appearance of Name B, Name C with the value of Name A.
If any of you would want to help me pointing how this could be done, I 
would be immensely grateful.

Thank you!

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted