Fist of all, I have only been using Access for little over a week so it is very possible a simple solution exists that I'm unaware of. Other than that, I feel like a have a decent grasp on Access overall.
I created a database from multiple different tables and a few queries, and my final table/query that tied them all together is massive (like 1.5 million rows big). Despite this, there is no data duplication and every single row is unique. The issue comes from a handful of the columns that can add multiple unique values which causes the data to fork into mostly redundant rows. Here a simple example that shows what I mean:
Product Type Components 1 A Material 1 1 B Material 1 1 A Material 2 1 B Material 2
The issue is non of these different "types" or "components" are mutually exclusive, so the data is completely valid. However, my data set is much more complex and I end up with a crazy amount of rows. I would like to show the data in this form if possible:
Product Type Components 1 A, B Material1, Material 2
Any ideas/suggestions?
Thanks!