I have a question regarding Excel. I have a large dataset and would like to find a way to organize my data in a way that I have similar cell values grouped together. Is this possible? Also, I have already filtered for columns of interest in my dataset.
Please find an example below of what I am trying to do:
| Distributor | Item |
|---|---|
| Target | watch |
| walmart | lamp |
| sobeys | watch |
| frescho | wallet |
| best buy | watch |
| staples | lamp |
| canadian tire | wallet |
Would like to turn above into:
| Distributor | Item |
|---|---|
| Target | watch |
| sobeys | watch |
| best buy | watch |
| walmart | lamp |
| staples | lamp |
| frescho | wallet |
| canadian tire | wallet |
Is there a way to do this automatically? Thanks!