Create a visual table with one ID linked to multiple categories or details

Good day, I created a viual (tabel) but the outcome is not what i expected. Issue: 1. The system displays one ID 3 times and links each ID to a category or detail in three seperate rows (see pictu...