Filter repeated values on array 2D

[leandrofeder]

Hello,

I am trying to create a filter to display the goals of my department, where each column corresponds to the month of the year and the status of each goal.

I need to filter all the repeated data from the left and display it as in the array on the right, with the 12 columns, even if the item in the array is empty, I need to point that out.Can you help me with this?

[altenbach]

The filtering rules are not obvious from your description, for example there is nothing that resembles a "month" and there are fewer that 12 columns

Please explain the filtering rules in a few more sentences and what result you expect from the current array diagram constant.

(also note that it was nice to do a "save for previous", but the concatenating string tunnel did not exist in earlier version and the code is broken. Easy to fix, see below)

Part of the program looks like a mutilated version of my code. Where did you find it? You should also replace the variant attributes stuff with a map, of course.

[mcduff]

Here's a start that CA can fix. 🙂

[cordm]

Not entirely sure if this is what you want, I made some assumptions but it looks sort of like your expected result.

I transposed the input to iterate over columns instead of rows and replaced empty strings with the string "Empty". That was mostly it.

It is not exactly the same output as your image shows, but I assume that is because of incomplete data.

[altenbach · Accepted solution]

Taking some guesses, here's what I might do:

It is not obvious what sort order you want in the output columns. they are not sorted by occurrence in your example.