Repeat the Occurrence of a text with condition

[msharma864512]

Hi,

I am looking for a way to repeat the occurrence of a text with condition in another worksheet. Details are in the attached spreadsheet.

Regards,
Manish

 

[vletm]

msharma864512
Do You mean something like below case based Your writing?

What would You like to yellow column?
... expected results?

 

[msharma864512]

msharma864512
Do You mean something like below case based Your writing?
View attachment 77430
What would You like to yellow column?
... expected results?

Something like this

 

[vletm]

msharma864512
Above won't match with Your writings...
There should be 11 Regions based Your given sample
... seems You've changed it to other ... and there should be 16 Regions.
Could You use Filter or Advanced Filter to get your ... results?

 

[msharma864512]

msharma864512
Above won't match with Your writings...
There should be 11 Regions based Your given sample
... seems You've changed it to other ... and there should be 16 Regions.
Could You use Filter or Advanced Filter to get your ... results?

Sure.. will try using Advanced filters or can try with Power Query as well