merge folder, but just the 30 first rows

[Raggsokk]

I have a sharepoint folder with billing information, that I would like to merge together.

Problem is that the last part of the exel files as a row with text, that for some reason gives errors.

I don't need this information in my report, so a solution would be to just merge the 30 first rows.

Is there a way to do that?

[PhilipTreacy · Accepted solution]

@Raggsokk 

Yes, before doing the merge, on the Home tab of the Ribbon click on Keep Rows -> Keep Top Rows and then specify 30.

Phil