ylliX - Online Advertising Network
Vertex AI - Antrophic and Mistral models: Why does it require Imegen access?

Is there a way to get each value from a table then connect with it’s title by row in a table


enter image description here

I have a table manage list of items (Green row), and its quantity by using a table (like matrix). But in the end I want to combine it into one single string by each row, represent the quantity follow by item name. For example I want to get the solution like [TARGET ANSWER] column. Is there anyway to do it by formula ?

I have tried using CONCATENATE to connect the values and items, but it too long. And later on if I added new items I have to change the formula again.

English is not my first language, sorry if it hard to understand. You can check the image for better understanding.



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *