Hello,
I need help figuring out a formula that can replace the cells that contain an "X" with the number in the last column of each row. I'm looking to leave the cells that are blank as they are. Below is an example of what my table looks like:
Tom x 1
Tom x 2
Tom x 3
Ben x 4
Ben x 5
Ben x 6
Ana x 7
Ana x 8
Ana x 9
Eventually I would like to group all the results for Tom, Ben, and Ana in one row as below:
Tom 1 2 3
Ben 4 5 6
Ana 7 8 9
Can anyone please help me figure out how to do this? Thanks!
Bookmarks