Hello,
I'm having an issue with sorting and making a list of data from two columns. In this example let's say we have 4 types of products (AAA,BBB,CCC,DDD) with various quantities like in picture below.
Is it possible to filter through each product, sum up the quantities and list it out into a single cell where it would be divided by a ; mark. For example it would look like this.
Where the end result is in D22 cell. If there is a thread where a similar issue was resolved, could you please link it, I have been unable to find a solution.
Thank you in advance and kind regards
I'm having an issue with sorting and making a list of data from two columns. In this example let's say we have 4 types of products (AAA,BBB,CCC,DDD) with various quantities like in picture below.
Is it possible to filter through each product, sum up the quantities and list it out into a single cell where it would be divided by a ; mark. For example it would look like this.
Where the end result is in D22 cell. If there is a thread where a similar issue was resolved, could you please link it, I have been unable to find a solution.
Thank you in advance and kind regards