I need to split a table into 4 columns while the data has two columns. There result might look like this:
The data is something like this:
I have the following table configuration:
Row group expression:
=ceiling(rownumber(nothing) / 2)
Column group expression:
=rownumber(nothing) mod 2
Table filter:
For some reason as th first image show the result has two extra empty rows.
No matter what I do I cannot get rid of them. However, teh same technique would profuce the correct results for the same number of original rows.
The problem only happens where the source table woud have two rows after filtering.
Thanks








