tonyrensya
New Member
- Joined
- Jul 24, 2013
- Messages
- 21
- Office Version
- 2019
- Platform
- Windows
- MacOS
Hello all,
I have a list of data in the table 1, how can I get the data list in Table 2 with formula?
I can use excel 2019 or google sheet. Thank you!
I have a list of data in the table 1, how can I get the data list in Table 2 with formula?
I can use excel 2019 or google sheet. Thank you!
Table 1 | 1 | 2 | 3 |
Apple | Tom | Peter | |
Orange | John | May | Peter |
Banana | Tom | May | John |
Table 2 | |||
Tom | Apple | Banana | |
John | Orange | Banana | |
May | Orange | Banana | |
Peter | Apple | Orange |