Filtering for specific rows and concatenating cells within that row
I have made some headway on this one, but falling short. I need to filter for rows with a specific cell value. Then once found, return a specific cell and concatenate a group of other cells in that row. What I have working is only an attempt at the filter and concatenation but my formula is concatenating all rows with the specific cell value “BUNDLE IDENTIFIER”. I think if I had a unique value , I could reduce the scope. I know there has to be a better way.
I have made some headway on this one, but falling short. I need to filter for rows with a specific cell value. Then once found, return a specific cell and concatenate a group of other cells in that row. What I have working is only an attempt at the filter and concatenation but my formula is concatenating all rows with the specific cell value “BUNDLE IDENTIFIER”. I think if I had a unique value , I could reduce the scope. I know there has to be a better way. Read More