Sort column B by another column A, except the column B has duplicated values, is missing values, and contains unexpected values
I've tried solving this myself, but I am absolutely lost! I'm hoping you guys could help me.
I have column A, which is a list of material numbers in a specific order (not numerical, but custom for me and very helpful). I want to sort my data (ie columns B through H) by this column A by matching column B to column A.
However, column B is missing values, has duplicate values, and has values that aren't in column A. I want to keep the duplicate numbers together while inserting the new values to the end.
Example:
| A | B | C | D... |
|---|---|---|---|
| Fish | Dog | A | Blah |
| Dog | Kitty | S | Blah Blach |
| Kitty | Horse | D | Yad |
| Mouse | Kitty | C | Blah Blaaaah |
| Horse | Mouse | A | Yada Yada |
| Goblin | Z | Tons of stuff | |
| Fish | Q | Ect Ect Ect |
Would sort to:
| A | B | C | D |
|---|---|---|---|
| Fish | Fish | Q | Ect Ect Ect |
| Dog | Dog | A | Blah |
| Kitty | Kitty | S | Blah Blach |
| Mouse | Kitty | C | Blah Blaaaah |
| Horse | Mouse | A | Yada Yada |
| Horse | D | Yad | |
| Goblin | Z | Tons of stuff |
Hopefully, this makes sense. Helper columns, etc, are all good. I'm also looking for something that is relatively reproducible as I have to generate a completely new spreadsheet every shift. Thank you so much!
[link] [comments]
Want to read more?
Check out the full article on the original site