Hi Forum, your help would be greatly appreciated, i am unsure how to start with a new pivot table.
i have a record of attendees to each event that i would like to total in a pivot
each row could be unique number starting from 1
and then the next column would be the entry DAY or EVE
and then would be the data . so in column 3 i would need to enter the names of the attendees, it may be anything from 3 names up to 20 names.
how i have it in my mind is i would need a new row for EACH attendee OR put a, attendee name in a new colomn.
Just dont know how to get started with it all.
the end result would be to run a PIVOT TABLE to see for eg how many times JAMES has attended in the EVE.
As said, any help id massively appreciated. ( i have read some tutorials and have some knowledge but just unsure how to START recording it )
thanks
Steve R
Bookmarks