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

Pam Lebeck

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?

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

Unknown

This content has been removed.