Return data from

[tantraaminulloh]

I have 2 column in google appsheet, productname and qty, and I want to return data from productname column as a list. And if there is a row in product name that have multiple qty, also return it multiple times in that list

[WillowMobileSys]

Are you asking for a Google Sheets function to do this or are you asking how to make this happen in AppSheet?  If in an AppSheet app, then we need to know WHERE you are trying to view the returned data and in what format you wish to view it.

[tantraaminulloh]

I'm asking how to make this happen in AppSheet. I want to view the returned data on different table from the data source table and in list format or anything that separated with commas. Sorry for my unclear question