https://youtube.com/watch?v=TjNnYGatTjoIn this tutorial let us see how to extract multiple matches into separate rows in Excel Here we will be using an array formula with a combination of Index and…