Combining Data

[jarrodexcel]

Hey guys, Struggling here with a big project of mine and really need some help!

So the data i get in has two columns, a and b. In a it provides me with two answers either yes or no. This tells me if this was planted or not.
Column b provides me with my trees data tag. i need to find a way to differentiate the yes and no data with the tree data and sum it all together in one column.

I have uploaded an image to show this. Top row is how the data gets downloaded.

Bottom row is how i need the formula to present the data.

Any advice would be much appreciated !!!

Thank you

 

[Fluff]

Can you post the data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[jarrodexcel]

Apologies, my laptop does not allow for external downloads so this is all the information i can provide at the moment

Yes,No,Yes,Yes,No	105-Appletree,110-Strawberry fruit,108-Fig,105-Appletree,105-Appletree
1x ABC110-Strawberry fruit, 1x ABC105-Appletree

 

[Fluff]

Thanks for that.
How about

Fluff.xlsm
	A	B
1	Yes,No,Yes,Yes,No	105-Appletree,110-Strawberry fruit,108-Fig,105-Appletree,105-Appletree
2
3	1x ABC110-Strawberry fruit, 1x ABC105-Appletree
Main

Cell Formulas
Range	Formula
A3	A3	="1x ABC"&TEXTJOIN(", 1x ABC",,IF(TEXTSPLIT(A1,",")="No",TEXTSPLIT(B1,","),""))

 

[jarrodexcel]

Thanks for that.
How about

Fluff.xlsm
	A	B
1	Yes,No,Yes,Yes,No	105-Appletree,110-Strawberry fruit,108-Fig,105-Appletree,105-Appletree
2
3	1x ABC110-Strawberry fruit, 1x ABC105-Appletree
Main

Cell Formulas
Range	Formula
A3	A3	="1x ABC"&TEXTJOIN(", 1x ABC",,IF(TEXTSPLIT(A1,",")="No",TEXTSPLIT(B1,","),""))

This is perfect ! you have helped me out so much ! one step closer to finishing my spreadsheet ! absolute hero

 

[Fluff]

You're welcome & thanks for the feedback.