I would like to flatten the following table.
| Major | Minor |
|---|---|
| Apple | Apple |
| Apple | Banana |
| Banana | Banana |
The pattern then continues for other fruits for another 100 rows.
The result that I would like to see is:
| Major | Major – Minor | Minor |
|---|---|---|
| Apple | Apple – Banana | Banana |
How would I go about approaching this? I am thinking about using self joins but cannot wrap my head around it
Thanks
1