Combining two data sets

[ToddCheever-FMR]

Hello All! So I am looking to combine two data sets into 1 for a report. Data Set 1 is more of a header with specific columns on it; Data Set 2 is what I'm looking to load but both data sets need to be on one report in order for it to work how I'm designing it.

Data Set 1:

DS1C1	DS1C2	DS1C3	DS1C4	DS1C5
DS1R1	DS1R1	DS1R1	DS1R1	DS1R1

Data Set 2:

DS2C1	DS2C2	DS2C3	DS2C4	DS2C5	DS2C6
DS2R1	DS2R1	DS2R1	DS2R1	DS2R1	DS2R1
DS2R2	DS2R2	DS2R2	DS2R2	DS2R2	DS2R2

Desired Output:

DS1C1	DS1C2	DS1C3	DS1C4	DS1C5
DS1R1	DS1R1	DS1R1	DS1R1	DS1R1
DS2C1	DS2C2	DS2C3	DS2C4	DS2C5	DS2C6
DS2R1	DS2R1	DS2R1	DS2R1	DS2R1	DS2R1
DS2R2	DS2R2	DS2R2	DS2R2	DS2R2	DS2R2

Essentially, I'm just looking to plop Data Set 1 on top of Data Set 2.

Right now I'm sitting at both data sets having been "selected"

[cjaneczko]

Does something like this work?

[ToddCheever-FMR · Accepted solution]

@cjaneczko @MarqueeCrew  - Thank you for your input! It was actually a little simpler than I thought. I dropped 2 basic table tools to the right of my selects tools for each data set.

Once in table format the two data sets can be combined using the union tool and it maintains both. However, it does create a merged cell due to the column mismatch. So I might have to leave the blank column in the header in order to get it to line up right for my uploader.