Question re public data collection and public custom reports (removing personal data)

Welcome to the community, @christiaank! Maybe you could link the data to excel power query or the power bi` and share it with limited variables to be made public. In this case, these support articles should be helpful:

And this one too …

Or as an alternative, you could also remove the personal information when the users submit the submissions to the server as outlined in the post discussed previously: