Forum Discussion
dataconsole
3 years agoFrequent Visitor
CONCATENATEX using a virtual table from a variable
Hello, I made a matrix visual listing counts of Customers, New customers and Repeat Customers. I wanted to extract the name of the Repeat Customers (Repeat Customers Pseudo) using CONCATENA...
- 3 years ago
Hi dataconsole
Apparently you have at least one blank customer clrarly indicated by the comma at the beginning of the concatenated text.
tamerj1
3 years agoCommunity Champion
Hi dataconsole
Apparently you have at least one blank customer clrarly indicated by the comma at the beginning of the concatenated text.
dataconsole
3 years agoFrequent Visitor
Thank you tamerj1 !
Indeed the sheet with sales data was also filled with some fees which were not related to sales, therefore customer. I forgot to filter by sales only