Helo,
I got data like below
How I can change it into something like this ?
I've tried combinig
=IF(COUNTIF(B2;"*"&$G$1)=1;C2;"")
with VLOOKUP AND INDEX functions but with no luck...
Thank you in advance for your help
Best regards
Maciej
Asked
Active
Viewed 37 times
0
-
1Are the Value1, Value2, Value3 numbers or text? – BigBen Nov 19 '21 at 18:47
-
All are text:-) – Maciej Mazurek Nov 19 '21 at 18:52
-
here is a good guide to doing 2 value lookups: https://stackoverflow.com/questions/42492758/vlookup-using-2-columns-to-reference-another/42493697#42493697 – Scott Craner Nov 19 '21 at 18:56
-
Which version of excel do you use? – OverflowStacker Nov 19 '21 at 19:29
-
Use Powerquery for such transformations. Few clicks. – JvdV Nov 20 '21 at 06:15
1 Answers
0
If you have Office 365 you could achieve this using:
=TRANSPOSE(SORT(UNIQUE($B$2:$B$11))) in B13
=SORT(UNIQUE($A$2:$A$11)) in A14
=IFERROR(INDEX($C$2:$C$11,MATCH(1,($A$2:$A$11=@$A$14#)*($B$2:$B$11=TRANSPOSE(@$B$13#)),0)),"") in B14
P.b
- 8,293
- 2
- 10
- 25