u/ForeverDMenergy

I'm leaving my job so naturally I need to make all my files accessible to my replacement.

I've uploaded everything from offline onto a sharepoint but I'm having trouble with onedrive.

I have a number of folders that I've shared with others in the organisation. Some are linked to MS forms etc for ongoing data work.

Presumably the folders will be deleted with my account. How do I allow everyone to maintain access to the files once I'm gone?

I tried moving the excel sheets linked to forms to the sharepoint, but this disconnected it from the form.

I need to analyse some data from an MS form and I cannot for the life of me figure out how to clean it up into a manageable format in the way I need. I'll be referencing the photos in the comments

Context:

- Participants are in groups (A, B, C, D) completing activities (1, 2, 3)

- Some groups do the same activities as others (E.g. group A does activities 1 and 3, groups D does all 3)

- For each activity, participants answer the same review questions on a likert scale.

- This means that A will review activities 1 and 3, D will review them all etc.

This results in a long table of data, with huge gaps that is hard to read (The example in the comments shows 4 groups and 3 activities. In reality, there are 39 groups across 15 activities).

I want to sort it into a manageable table where each person has a different row for each activity they did, with columns for each question, that can be sorted by person, group, or activity (hopefully the image describes this better)

The main issue is that it needs to be dynamic. The same questionnaire will be copied given to the next set of participants, so I need to be able to copy and paste the formula into the next spreadsheet and have it update dynamically as the responses come in.