Is this possible in Excel?

[danielson81]

Hi,

 

Just wondered if the following was possible in excel.

 

Basically have a spreadsheet with three columns of data, users username for different system ,(ie email, network, sims etc)

 

Is there a magic formula that can go through them all, and sort/put them together in a row.

 

Currenty its about 80 rows:

 

simsuser emailuser networkuser

 

jsmith john.smith john smith

dcameron david.cameron david cameron etc

 

However some people dont have a email or sims account so doing an A-Z sort results in gaps and manually dragging cells across.

 

eg

 

simsuser emailuser networkuser

 

jsmith john smith

david.cameron david cameron etc

 

Doing it to tidy up usernames and duplication etc in schools. Eventually will probably use it to migrate to Office365, but thats a different story!

[LosOjos]

I'm not sure I follow - you want all of the usernames for a person in one cell (regardless of how many usernames they have)?

 

If that's what you're getting at, your formula would be something like

 

=trim(if(isblank(A1),"",A1)&" "&if(isblank(A2),"",A2)&" "&if(isblank(A3),"",A3))