Data Prep for Software Transition

I’ve been tasked with preparing approximately 7,000 lines of membership data for import into our new system. I have a solid understanding of what needs to be done to build the master data sheet for import, but I’m also aware that I don’t have the technical depth to execute every part of this process independently.

About the Data:

• Sheet 1: Base membership data + contact info ~7,000 records, each with a unique System ID (primary identifier)
• Sheet 2: Member credit balances ~50 records, includes System ID, needs to be merged into Sheet 1 by way of similar System ID
• Sheet 3: Member debit balances ~100 records, includes System ID, also needs to be merged into Sheet 1 (after Sheet 2 fields) by way of similar System ID

Tools / Limitations

I’m currently using the Excel web application via SharePoint, and I’m noticing that some features shown in tutorials (like certain tabs or tools) aren’t available to me.

I’ve come across concepts like:

• Left / Inner / Outer joins (via Python/Pandas)
• Power Query
• Indexing / lookup methods

However, I don’t have coding experience, and I’m unsure whether my current version of Excel supports Power Query or similar functionality.

Questions:

1. What is the simplest way for a beginner to merge data into corresponding columns using a shared System ID?
2. Is working with around 7,000 rows (and potentially up to 20,000 if guest data is included) too large to handle using column-by-column lookup methods?
3. Would you recommend cleaning and validating the data before merging the sheets, or is it better to complete the merge first and then handle data cleanup?

---

I'll likely have several more questions over the next few days as I work through this process. If anyone is willing to follow along and offer guidance, I would really appreciate the support.

The final data import sheet must be completed and ready to share by April 27. Thank you in advance for your help!