I have two sheets that need to be consolidated into a single comprehensive spreadsheet.
1st Sheet is Customer Information
2nd sheet is pet information
can be a 1:many relationship if customer has multiple pets
both sheets share a common column of customer id
I want to make it automatically consolidate the two sheets into a single sheet that I can upload into our platform.