Dashboard Table - Filter out columns instead of entries

[AbigailEbelherr]

I am wondering if there is a method of filtering out null columns in the Table widget on the dashboard and not the whole entry.  I have features on a map, and some of them have funding for two years while others have funding for three years.  When I select the ones that only have two years of funding, I want only those two years to be shown rather than the blank third year:

I need the Funding Year 3 column added to the table for those features that do have a third year, so I cannot remove it from the table.  When I try to use the filter options, it just removes the whole feature if Funding Year 3 is null instead of the column.

Any help is greatly appreciated.

[MobiusSnake]

I don't think there's a way to do this, but there might be a reasonably clean alternative.

You could use a Data Expression (written in Arcade) to convert your records to 2-or-3 distinct records, depending on whether it has two or three years' funding.

For example, if you had a record like this:

Year1	Src1	Amount1	Year2	Src2	Amount2	Year3	Src3	Amount3
2024	A	10000	2025	B	15000	2026	C	20000

You could convert it to this:

Year	Src	Amount
2024	A	10000
2025	B	15000
2026	C	20000

Whereas if you only had the first six columns in your record, you'd end up with two rows in your result.

I think this would give your table a nice appearance, no gaping blank spaces, but how easy it will be will depend on how familiar with Arcade you are.

[AbigailEbelherr]

Thank you for offering a solution.  I am not very familiar with Arcade.  We decided to go in a different direction with displaying the data, so this won't be needed for now, but I appreciate the help.