0

I have my data like this:

Main ID    SUB ID    Info

1A         1A1     24572-16
1A         1A1     26553-17
1A         1A2     24572-16

I would like to return like this: IF 'info' have the same 'SUB ID' and 'MAIN ID'

return like this:

Main ID    SUB ID     Info

1A         1A1     24572-16; 26553-17
1A         1A2     24572-16

Is it something possible?

Simon GIS
  • 1,045
  • 2
  • 18
  • 37
  • Have a look over [here](https://stackoverflow.com/a/60772717/9758194). You basically need to go over the PowerQuery steps and you are done. Just realize you need to group by both column 1 and column 2 in step 3 of option 2. – JvdV Jul 10 '20 at 08:38

1 Answers1

0

If you want output result in separate cells then use below formula.

=IFERROR(INDEX($C$2:$C$4,AGGREGATE(15,6,ROW($1:$3)/(($A$2:$A$4=$E2)*($B$2:$B$4=$F2)),COLUMN(A$1))),"")

enter image description here

If you want to get output result in same cell then you have to use TEXTJOIN() function.

Harun24hr
  • 30,391
  • 4
  • 21
  • 36
  • I can get it work... Thanks for the help1 https://docs.google.com/spreadsheets/d/1uCGu9cCQWJMpU2a0hD6u81DyYY9SAPFlCL9DveSy4Pc/edit#gid=0 – Simon GIS Jul 13 '20 at 02:18