lvanderpol
New Member
- Joined
- Oct 14, 2019
- Messages
- 1
Hi all,
This is a challenge, at least for me. What I'm trying to achieve is the following: I've a big list of items with several specs. I want to project the matching items (with the same specs) in columns after the item to match.
Simplified example of the data:
<tbody>
</tbody>
Result wished for:
<tbody>
</tbody>
Is this possible at all? I tried and combined several index matches found on the forum, but non of them worked for this scenario. I really hope someone has a working solution, as I have thousands of rows and a couple thousand combinations I guess.
Many thanks in advance!
This is a challenge, at least for me. What I'm trying to achieve is the following: I've a big list of items with several specs. I want to project the matching items (with the same specs) in columns after the item to match.
Simplified example of the data:
Item | Spec 1 | Spec 2 | Spec 3 | Spec 4 |
car | 10 | 20 | ABC | DEF |
bal | 10 | 30 | ABC | GHI |
bike | 10 | 20 | ABC | DEF |
house | 20 | 30 | JKL | MNO |
table | 10 | 30 | ABC | GHI |
motor | 10 | 20 | ABC | DEF |
<tbody>
</tbody>
Result wished for:
Item | Related 1 | Related 2 | Related 3 | Related 4 |
car | bike | motor | ||
bal | table | |||
bike | car | motor | ||
house | ||||
table | bal | |||
motor | car | bike |
<tbody>
</tbody>
Is this possible at all? I tried and combined several index matches found on the forum, but non of them worked for this scenario. I really hope someone has a working solution, as I have thousands of rows and a couple thousand combinations I guess.
Many thanks in advance!