Forum Discussion
Solved
merge folder, but just the 30 first rows
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?
Yes, before doing the merge, on the Home tab of the Ribbon click on Keep Rows -> Keep Top Rows and then specify 30.
Phil
1 Reply
- PhilipTreacy
Super User
Yes, before doing the merge, on the Home tab of the Ribbon click on Keep Rows -> Keep Top Rows and then specify 30.
Phil