Is there a way to populate column 1 with the names from 2 other columns?
I am a volunteer for a local sports association. We need volunteers to make our competition days run smoothly, and I am trying to get the list of names on a million different documents (some CVS, some word, and some Excel) in to one solid document. I also am trying to track how many hours each person volunteers so that I can arrange a gift of sorts to the most generous people.
My main question:
Is there a way to automatically fill the "master list" column on the left (for example) with the names from the "list 1" and "list 2" columns, even if they appear multiple times? I have attached an example of what I mean, to the best of my ability. I have figured out how to do a Sumifs function to count the hours that apply just to "Brenda" for example, and have them saved so that I can track for each competition separately, as well as a total at the end of the year. But each competition has different people helping, and at different times, so I am trying to avoid manually having to go through each name entry in each competition... is that possible?
Secondly, one of the documents I was sent is an Excel with only column A used, which reads: the name of the person, next cell down empty, next cell down is their email, then another 2 cells down shows the next person. I think it has been copy pasted from an email list or something. Is there a function that can select each second cell with the email (for example) and move them to the B column on their own?
[link] [comments]
Want to read more?
Check out the full article on the original site