Copy Excel data content listed in 3 columns into a single column
My speadsheet looks like this:
Name Computer name count
Jones cpu1 5
Jones cpu2 6
Jones cpu4 15
I need for it to appear like this:
Name Computer name count
Jones cpu1,cpu2 and cpu4 26
How can this be accomplished. Thanks.
|