It seems to me it is possible to put multiple columns under the same name (i named the two columns Category). Then i have set up a filter by Category and it shows all values in the two columns. That solves my issue for now. Good luck with your project.