---
title: "Free Strata course on combining data files | Oplema"
description: "Learn to combine and reconcile messy files in a free hands-on Strata course: stack files, remove repeats, explain unmatched joins and unpack JSON."
url: "https://oplema.com/learn/many-sources"
updated: "2026-11-04"
---

Free · Beginner · 9 lessons

# Combine and reconcile data files

Free course, nothing to install. Learn Strata, Oplema's browser app for data prep, on month-end work: stack three shops' till files and work through the register, repairs, web payments and budget, explaining every row that doesn't fit, then build the month-end table. Each lab starts part-built and wrong, and you complete it.

[Start the course](https://oplema.com/learn/many-sources/combine-files-with-renamed-columns)

**Who it's for**

People who can build a simple flow in Strata and now have several files that must agree.

If you've finished [Build a report from a CSV export](https://oplema.com/learn/export-to-report), or can already place and wire blocks, read a preview and filter rows, you're ready.

**You'll be able to**

- Stack files despite renamed columns
- Remove repeated rows
- Attach and explain unmatched rows
- Match misspelled names
- Unpack crammed cells and JSON
- Reshape a wide sheet
- Fix someone else's flow

**You leave with**

A month-end table for fictional Kramerica Bikes' three shops, with every gap explained and built mostly unaided.

Each lesson ends with one line for the owner and a figure to check your result against. The last lesson fixes a colleague's flow, then has you build month-end yourself. Every lab runs in its lesson page.

## Course outline

### Bring the files together

1. [1 Combine CSV files when a column has been renamed Lab](https://oplema.com/learn/many-sources/combine-files-with-renamed-columns)
2. [2 Remove rows that appear in two files Lab](https://oplema.com/learn/many-sources/remove-rows-in-two-files)
3. [3 Find out why rows don't match in a join Lab](https://oplema.com/learn/many-sources/find-unmatched-join-rows)
4. [4 Label rows from a small lookup table Lab](https://oplema.com/learn/many-sources/label-rows-from-a-lookup-table)

### Untangle what the files hide

5. [5 Match misspelled names between two tables Lab](https://oplema.com/learn/many-sources/match-misspelled-names)
6. [6 Split packed cells into columns or rows Lab](https://oplema.com/learn/many-sources/split-packed-cells)
7. [7 Extract fields from JSON and reconcile payments Lab](https://oplema.com/learn/many-sources/extract-json-and-reconcile)
8. [8 Compare a wide budget sheet to actuals Lab](https://oplema.com/learn/many-sources/compare-budget-to-actuals)

### Fix and build month-end

9. [9 Debug a flow that runs but gives the wrong total Lab](https://oplema.com/learn/many-sources/debug-a-wrong-total)

## Start with lesson 1.

Stack files with renamed columns, remove repeated rows, explain unmatched joins, match misspelled names, unpack JSON and reshape a budget.

[Start the course](https://oplema.com/learn/many-sources/combine-files-with-renamed-columns) [Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata)
