How to add data tables with multiple criteria

I have a table with data, company, products, and related sales volumes. I want to split them into four columns. But it is not doable for company and products, as they are listed in two seprate rows. How can I insert the table to show all categories? Additionally, I have to insert columns from other file to this tab, however, with only one condition can be matched.


File spotfire_question.xlsx9.99 KB
Image icon insert_column.jpg200.86 KB

(1) Answer