This is in reference to the formula I need for cell F2 in the below image.
F2 shows the result I WANT:
I NEED: The Concat Formula to concatenate the data in Column B for each variant of whatever is in Column A. So if we know there are X versions of the item (based on function in C2), then the concatenate needs to step up X −1 times to draw the text string from Column A.
Can't figure out the best way to do this! I'm also OK with making new functions if they need to be referenced (like aggregate CONCATs in F, because I can then just write an IF statement to look for "BASE"...)
- I know the number in C2: it's the number of times the text in column A shows up
- I know the number in E2: it's the row number
- I know the result of D: if it's the first time the text in A shows up, it's "Base" otherwise it's "Variant"
- I know the text in Column A is always sorted