u/BowtiesandScarfs

I’m attempting to restructure my exam result tables..
▲ 2 r/excel

I’m attempting to restructure my exam result tables..

Hi, I’m attempting to organise an exam/date/result record list from the top layout to the bottom. Link to an image of example tables: https://ibb.co/v4BKL45S

So that the data results in one name followed by the exams attended and the date they attended on and the result scored. Each person can have around one to twelve events and is not consistent by any metric, and multiple people have attended the same exam multiple times.

Is there anyway to do this simply? Or will it have to be a manual process as I’m trying to avoid doing so, as I have close to 37,400 attendees for this period alone.

Any help appreciated and please let me know if I need to be clearer on anything. :)

u/BowtiesandScarfs — 3 days ago
▲ 3 r/gdpr

Sending a customer flowers?

In a recent interview a candidate was asked to give an example of excellent customer service they had or may give.

Their response was to send a customer flowers after hearing about a recent bereavement. Our company, and the ones they worked at previously, do not fulfil flower or other traditional gift deliveries meaning an external company would have been used.

My question is, if the customer only provided an address for billing purposes and/or for general correspondence; would providing their details to an external company to send them flowers or other gifts violate GDPR in anyway?

We’re in two minds about, leaning towards yes.

reddit.com
u/BowtiesandScarfs — 11 days ago