Hi,

In this issue,I have two worksheet namely "Data" and another "Expected Result".

Expected Result is the desired result which I want to achieve.The changes which is required is highlighted yellow and others are left intact.In the "Expected Result" worksheet a column is inserted in E where and specific data is pulled from B column which is self explanatory as it is highlighted clearly.

Hope this would be also solved as usually.Kindly be aware in actual data is very large.

The link to the file >>https://docs.google.com/spreadsheets...it?usp=sharing