If you have multiple sheets that you want to merge using consolidate that have repeating headers, we propose a workaround by creating a separate sheet that just contains the header. Please take a look at this demo sheet. If you want implementation support, please contact firstname.lastname@example.org.
Have more questions? Submit a request