Excel Records Master Consolidation

I have a set of Excel spreadsheets that collectively hold about 52,638 rows.
Sl No. / Certificate No.: Unique identifier/number for the issued Scheduled Caste certificate.

Issue Date: The date the certificate was issued (ranging from January 2011 to May 2026).

Applicant Name: Full name of the certificate holder.

Father's Name: Name of the applicant's father.

Address: Full residential address including village, post office (PO), police station (PS), district (Maldah), and state (West Bengal).

Gram Panchayat: The specific local governing body region (e.g., Pakuahat, Chandpur, Jagdala, etc.).

Caste: Category classification (all entries are SC).

SubCaste: Specific Scheduled Caste community sub-group (predominantly Rajbanshi, Namasudra, etc.).

Phone: Contact mobile number of the applicant.

Relation Details: Details of family lineage or older reference certificate numbers used for verification (e.g., relation type like Real Brother or Father, along with old reference certificate numbers).

Action: Status indicator or verification action tag (e.g., Verify).