I'm working on an Xpoter template and trying to get a filter result set into an Excel Table in the template.
When run the final Excel worksheet area with table is populated with the first column of information, and then the first record of the second column. After that everything else is blank. (Screenshot attached for reference)
A named range does work, but this does not provide the structured reference that I'm looking to use on dashboard in the template.
I've also tried a different filter in the template thinking it might be an issue there. Still get the same result.
Has anyone else run into this type of behavior, and what did you do to correct it?