see attached excel.
i have a list made by 4 columns. the columns C is not important, the columns A,B,D contains data i need to reorganize.
In column A there are values ("point"), some are repeated several times and for each one there are values in column B but only sometime in comlum D.
For every value ("point") i need to write, in a single cell, all the "types" and if a "value" is present it should be written between commas after the type.
is there a way to make it by formulas?
Bookmarks