~~~ Please read before posting. ~~~

Important: We need your Club Number at a minimum, and as many details as possible.
For further info please read This page before posting.

Reformat the Meeting Role Tally report

  • ebmay01
  • ebmay01's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 16
  • Thanks: 1

Reformat the Meeting Role Tally report

10 hours 28 minutes ago
#97060
Hello,

I just tried to use the Meeting Role Tally report for the first time, and love the fact that it contains counts for both previous roles and future roles! That said, I would like to recommend/request a formatting change. 

The current format has the roles in columns, and the members on rows. So, for a report with one member, there is one row and could be many, many columns. The report I ran contained 53 columns. My request is for the report to be formatted with roles on the rows, and members in the columns. Even if you ran the report for a whole club of 25 members, there would be only 25 columns (rather than 53 or more), and 53 rows, which is easier to read/review. It would also be easier to filter on specific roles.

Thank you for your consideration,
Beth May
President, Frederick Toastmasters (Club 1082)

Please Log in or Create an account to join the conversation.

  • Brian
  • Brian's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 10907
  • Thanks: 3632

Re: Reformat the Meeting Role Tally report

1 hour 15 minutes ago - 1 hour 11 minutes ago
#97066
Copy and paste the report into excel and you can manipulate it as you need.
Try pulling by member and date instead of all members.
Last edit: 1 hour 11 minutes ago by Brian.

Please Log in or Create an account to join the conversation.

  • ebmay01
  • ebmay01's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 16
  • Thanks: 1

Re: Reformat the Meeting Role Tally report

1 hour 1 minute ago
#97070
The report is an Excel download already. And I already pulled by member: as stated, the downloaded Excel contains one row (for one member) and 53 columns. Of course I can copy/paste/transpose to get it into the format I desire. My suggestion/request is to have that be the default format, because it is likely more useful for most - if not all - users.

Please Log in or Create an account to join the conversation.

  • Brian
  • Brian's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 10907
  • Thanks: 3632

Re: Reformat the Meeting Role Tally report

46 minutes ago
#97071
Excel has functions to do table rotation, Google and Gemini are your friends.

blog.udemy.com/excel-columns-to-rows/?ut...VYpQs2BoCDfkQAvD_BwE

Please Log in or Create an account to join the conversation.

Moderators: BrianHeniPamrhtaylor3marc33NotLiableNSBjgavinLcala305peterb323DebbieT
Time to create page: 0.145 seconds