Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I think the simplest solution is to split the tables i.e. D1 in rows in 1 table, other D's in the other table. You can then join the tables using equipment number and your other conditions. This will only work if there is 1-Many relationship. You can use Power Query to do this.
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
82 | |
55 | |
40 | |
20 | |
12 |