M
Mayte
i have a book that has 3 columns
A B C
id name accounts
i have 500+ entries, all w/different ids and names but the accounts are the
same because i only have 4 accounts.
what i need to do is add 4 columns (1 for each acount) and show in each new
column only the ids of the employees who are assigned to those accounts BUT
one after the other.
i ca ndo an if statement and it will give me the results but the returned
values in columns D-G won't in order. i mena, will have spaces in between and
i need them w/o any blanks... any ideas??
A B C D E
F G
id name accounts accnt-1 accnt-2 accnt-3 accnt-4
001 joe accnt-1 001 004 003
015
003 patrick accnt-3 010 005 007
023
004 louis accnt-2 105
005 fsavid accnt-2
007 ryan accnt-3
010 sam accnt-1
015 carlos accnt-4
023 oliver accnt-4
105 natalia accnt-1
A B C
id name accounts
i have 500+ entries, all w/different ids and names but the accounts are the
same because i only have 4 accounts.
what i need to do is add 4 columns (1 for each acount) and show in each new
column only the ids of the employees who are assigned to those accounts BUT
one after the other.
i ca ndo an if statement and it will give me the results but the returned
values in columns D-G won't in order. i mena, will have spaces in between and
i need them w/o any blanks... any ideas??
A B C D E
F G
id name accounts accnt-1 accnt-2 accnt-3 accnt-4
001 joe accnt-1 001 004 003
015
003 patrick accnt-3 010 005 007
023
004 louis accnt-2 105
005 fsavid accnt-2
007 ryan accnt-3
010 sam accnt-1
015 carlos accnt-4
023 oliver accnt-4
105 natalia accnt-1