Can I use a Join when trying to create a report from 2 sheets

I want to "Join" the data from one sheet to the other sheet in a Report using the Primary Field so that I only get 1 ROW with all the columns filled in. Instead, I get DOUBLE primary each with data populated only from the Sheet it came from which isn't useful at all.

Is this possible?

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi Pam,

    Not possible. Reporting just pulls in data from Sheets and allows for filtering, grouping and sorting. You can't apply formulas. Not yet, anyways.

    To do what you're looking for you'll need to merge the data from 2 sheets into a 3rd sheet and then report against the 3rd sheet. If your sheets are simple it's fairly easy. Don't know if it will work for your situation.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.