Uneven amount of data rowsI have 15,000 rows of data sites from one spreadsheet, and I am trying to include data from another spreadsheet. The research sites are the same in both, although there are less rows in the data I am trying to input (about 1900 rows). I want all of the rows to match up, even if there are many duplicates. How would I go about doing this?
Data TableRe: Uneven amount of data rowsHi @marshmadness98 ,
I'm not sure I entirely understand your issue, but it sounds like you basically have two data tables with the same number of columns (same names, too), but different number of rows.
I think what you'll want to do is concatenate the tables: Tables > Concatenate. This basically appends one data table to the other, like attaching one to the "bottom" or last row of one with the other.
Give that a try and see if it's what you are looking for. The other option could be to Join, but it doesn't sound like that's what you want to do.
Hope this helps!,
DS
Re: Uneven amount of data rowsUnder
Tables=>Join
there is an option that allows for the elimination or inclusion of duplicates
Re: Uneven amount of data rowsHey, thanks so much for your response! I actually realized I do need to join the data together. So, I have two different Excel files I am trying to merge into one. Essentially, one of the files has a lot more rows. The file I am trying to add in matches up with the research sites from the first data table, although there are a lot less rows. The column name is this same. I'm trying to join the files in such a way that I'll end up with as many rows as the longer file, but so everything will match up. I am trying to include the type of marsh for each research site essentially, and I want that to duplicate as many times as possible to fill in the first data table fully.
