Iniside a view, I have a relationship set up between two tables: departments and employees. I want to use a view to display it in the following format:
Department A | Department B | Department C
Employee 1 Employee 5 Employee 6
Employee 2 Employee 7 Employee 8
Employee 3
Employee 4
But until now, using the grid and table style, I'm only able to display it as follow:
Department A
Employee 1
Employee 2
Employee 3
Employee 4
Department B
Employee 5
Employee 7
Department C
Employee 6
Employee 8
I know I could create a module or a block for this but I would prefer to leave it inside a view and enable our client to change it whenever he wants to. How would you solve this requirement? Is there a view hook that would allow me to access the data and wrap my HTML table around it?