I'm doing a Google spreadsheet and I can not find the solution to mark that a cell is published in different columns, this must be specified in all the desired cells but I can not find the way, the only thing I have achieved is that it works by rows or columns. The "Remove duplicates" add-on is not an option.
Excel example
Demomento this is what I have managed to do, I leave a link with an example
Right now I would only work by columns, what I need is for this to work in the form of a quadrant, I do not know if I explain myself well.
With a small modification I have managed to work in quadrant, now the problem is that this goes for days, I do not know if I can do it without having to do a column per day.