I receive data that is routinely the same, but mixed in a different order nearly every time. What I want to do is have a preset formula that will pull specific parts from the data and put them on the side. For example:
I might be given this data, but only want Jake and Matt's name and data.
So I'd like excel to transfer those Jake and Matt to one side along with their respective data, like the following.
Like I said though, names could be mixed up every time, so I need a formula that finds the Name and pulls it and its data to the side.
Thanks in advance!
I might be given this data, but only want Jake and Matt's name and data.
Donna | 56 | 67 | 78 | 89 | ||||||
Jake | 23 | 34 | 45 | 56 | ||||||
Matt | 98 | 87 | 65 | 54 | ||||||
Bert | 54 | 43 | 32 | 21 |
So I'd like excel to transfer those Jake and Matt to one side along with their respective data, like the following.
Donna | 56 | 67 | 78 | 89 | Jake | 23 | 34 | 45 | 56 | |
Jake | 23 | 34 | 45 | 56 | Matt | 98 | 87 | 65 | 54 | |
Matt | 98 | 87 | 65 | 54 | ||||||
Bert | 54 | 43 | 32 | 21 |
Like I said though, names could be mixed up every time, so I need a formula that finds the Name and pulls it and its data to the side.
Thanks in advance!