Hi,
I'm a very lightweight user of Excel and until now have been able to do everything I need to do using the help files and whatnot. Now I need to manipulate my data in a way that is not simple. I have to create a one-to-many relationship and return the multiple values concatenated into a single field.
Example (I've got 3000+ rows of this and only 347 unique server names):
<tbody>
</tbody>
Desired outcome:
<tbody>
</tbody>
I don't understand scripting or array formulas, but I can learn! I just need to be pointed in the right direction. I hope I've made this clear - it's pretty simple and I could do it in notepad if it were just a few rows, but 3000 is too daunting!
Thanks in advance for reading and helping!
--Alyssa
I'm a very lightweight user of Excel and until now have been able to do everything I need to do using the help files and whatnot. Now I need to manipulate my data in a way that is not simple. I have to create a one-to-many relationship and return the multiple values concatenated into a single field.
Example (I've got 3000+ rows of this and only 347 unique server names):
Object_Path | MemberName |
Server1 | AdminGroup1 |
Server1 | AdminGroup2 |
Server1 | AdminGroup3 |
Server1 | PowerUsers1 |
Server1 | PowerUsers2 |
Server2 | AdminGroup1 |
Server2 | AdminGroup3 |
Server2 | PowerUsers1 |
Server3 | AdminGroup1 |
Server3 | AdminGroup2 |
Server4 | AdminGroup1 |
Server4 | PowerUsers1 |
<tbody>
</tbody>
Desired outcome:
Object_Path | MemberName |
Server1 | AdminGroup1, AdminGroup2, AdminGroup3, PowerUser1, PowerUser2 |
Server2 | AdminGroup1, AdminGroup3, PowerUsers1 |
Server3 | AdminGroup1, AdminGroup2 |
Server4 | AdminGroup1, PowerUsers1 |
<tbody>
</tbody>
I don't understand scripting or array formulas, but I can learn! I just need to be pointed in the right direction. I hope I've made this clear - it's pretty simple and I could do it in notepad if it were just a few rows, but 3000 is too daunting!
Thanks in advance for reading and helping!
--Alyssa