Forum

That's great! I've transformed the data table with Power Query so that the Subjects, Teacher names and Assessments fit in a single cell with line f...

Why not with formulas using COUNTIFS, or (power) pivot tables? I've included some examples in your workbook.

I don't believe you can not include hyperlinks from a data source in a pivot table, so your other solution would be the way to go. So I would you forg...

But please answer my question with regard to how the certificates look like, I'm sure it's relatively easy to resolve. So if you can post an example o...

Thanks for the file. However, I don't fully understand how it relates to your question and where the hyperlinks come into play.

Please provide some more details. How does the report look like? Why do you want to use VBA?

You're welcome. Have you resolved it now?

In E2, enter: =SUMIF($B$2:B2,B2,$C$2:C2) and copy down.

It's difficult to visualise what you are working on. Can you upload your file (remove any confidential information)?

You could begin by clarifying how such a certificate should look like. Especially one with multiple commendations. Depending on that, you could use Po...

Great! Good luck with learning more.

I believe all can be done in PQ, but if you send me some anonymous data (like I had in my file) I can have a look. Important that you indicate in that...

I meant to write Transform tab but somehow typed Transfer. Sorry about that. Not sure what you mean by "how Power Pivot integrates with the query e...

Okay, let's have a closer look at the pivoting step. In the Personnel query. After merging and expanding the Payroll data, the pivoting is done within...

Could you please upload your file? Then we can see what you are working on.