Currently, I have a dataset which looks like this:
I am wanting to produce something that looks like this:
Rather than having each different activity displayed as a separate field name, I simply want to convert this into a single field name "Activity" then list the different activity types as a value on separate rows instead of the field header. I then want to apply the relevant frequency field to each activity.
Anyone have any ideas?
Thanks in advance