Share via

Pivot tables

Anonymous
2024-08-20T10:27:21+00:00

How do I get the data in the first screenshot into the format in the second one using pivot tables. If there is a better way to do this than pivot tables, I'd be grateful for any suggestions. Tks Cliona

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-20T14:41:52+00:00

    You are welcome:) You may also give feedback on it.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-08-20T13:58:05+00:00

    that will work perfectly THANKS Cli

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-08-20T13:39:41+00:00

    I have put formula on your test file. Is that one you want?

    =SUMIF('6. Midlands Harm Reduction'!$A$2:$A$37,$A2,'6. Midlands Harm Reduction'!B$2:B$37)

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-08-20T13:19:25+00:00

    Hello

    here is the link to the data file - Midlands Harm Reduction.xlsx

    Was this answer helpful?

    0 comments
  5. Anonymous
    2024-08-20T13:08:30+00:00

    Could you share a test file? Then I can test functions on it.

    For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.

    *Please make sure you have removed any sensitive or private information in the sample file before uploading.

    Was this answer helpful?

    0 comments