Merge 2 column names from separate sheets into one in a single report
I want to create a single report that can be circulated on an email that pulls data from 2 separate sheets. In some cases I've been able to align the column headings, for example "Assigned To" is common across both sheets. However, in renaming that column, the resulting report no longer has an option to "Group" based on that value (all other columns are listed). I've refreshed, saved, exited, removed the sheet/re-added etc but the field is no longer visible. Why?
Also there is another field that I would like to group on but can't rename. In one sheet it is called "Due Date" and in the other sheet "End Date". It's like I want to put a "JOIN" formula in the Report so it just shows one column not two, and I don't think I can do this in either of the source sheets, or create a 3rd source sheet. There's no way to create a column "alias" is there so that you can "behind the scenes" call both the same thing?