Hola
I am trying to concat some cells but there is not a pattern so I am having difficulties to find a easy way to do it. We are getting an extract from our website that include elements and attributes attached to a category. Each category is a column. If a element has various attributes for a category, the export is spelling the attributes in different rows, generating blank spaces between elements. The desire output is all the attributes for a category in the same cell delimited by comma.
Is there any macro or PQ to do this easily? I have attached a sample with demo data. Please, let me know if you need more info as I am not sure if I have explained really clear :P
TIA
Bookmarks