Hello, I'm new here and I have a question:
To make things easier i'll do an example
Say i have 5 columns of name, language, address, job, nickname
A person might have 2 addresses or know 2 languages.
The problem is when i import to excel from a very large database it imports all data in different columns for example
john a. english 55 Street painter johnny
john a. spanish 55 Street painter johnny
john a. english 22 Street painter johnny

and so on for every name. The question I have is if i can in excel add each persons data in extra columns say for example address 2 or job 2 and have the following

john a. english 55 Street painter johnny spanish 22 street

Thank you.