I am trying to find a formula to list select data from one tab into tab sheet on the same document.

For example, say Tab 1 had the following information listed in Column A:

Apples AOranges AOranges BApples B

I want Tab 2 to automatically find all instances where Apples appear in the list and then list them like this:

Apples AApples B

At the moment, all I can do is a formula to only show where Apples are listed, but the formula leaves lots of blank spaces in between the listings, so it looks like this:

Apples A  Apples B

Is there any way I can just get specific data from one tab to be listed in another tab with no gaps in rows?

​I am trying to find a formula to list select data from one tab into tab sheet on the same document. For example, say Tab 1 had the following information listed in Column A:Apples AOranges AOranges BApples B I want Tab 2 to automatically find all instances where Apples appear in the list and then list them like this:Apples AApples B At the moment, all I can do is a formula to only show where Apples are listed, but the formula leaves lots of blank spaces in between the listings, so it looks like this:Apples A  Apples B Is there any way I can just get specific data from one tab to be listed in another tab with no gaps in rows?  Read More

​