Merging multiple rows with same value

Question

I need to transform the table on the left into into the format of the table on the right. The original table is in MS Access and I am struggling with this problem.

I found many examples where this was done with min/max aggregated function, but since there are multiple rows for each value, this does not work.

Answer 1

Your tables don't appear to be consistent -

For example, the six original values associated with Type A (highlighted in yellow in the left-hand table below), become six different values (as highlighted in yellow in the right-hand table):

Answer 2

To transform (or "pivot") an Access table, you need a Crosstab Query.

The easiest way to create a Crosstab Query is with the Crosstab Query Wizard.

---

More Information:

• Office.com : Create a crosstab query by using the Crosstab Query Wizard

• YouTube : Create a Crosstab Query

• Paragon : What is a CrossTab Query?