Aligning Columns in a Report that is pulling Data from Multiple Sheets


I have a Primary Column in two sheets with the same data - Project IDs.

The subsequent columns are different, however.

One sheet has team members info.

The other sheet has budget info.

Can I create a report that pulls from both sheets, and the Team Member info is side-by-side with the Budget information?

As I understand it, if I merge two sheets into one report, Smartsheet will place the data from one sheet underneath the data from the other.

Is that an unavoidable structure to Smartsheet's report?

Appreciate the feedback. Thanks!