Multiline Notes
You and some friends log activity in a notetaking app, but the export crams each person's notes into one comma-separated cell.
Convert it to a one-note-per-line scheme: each note on its own row, with the author named only on their first row and blank below. People appear more than once — keep those entries separate, and keep everything in the original order.
Work on it
- Make a copy of the template — it becomes your private sheet.
- Solve it however you like — helper columns and extra tabs are fair game. The one rule:
the grader swaps
INPUTfor other datasets, so never put your own content insideINPUT. - Check yourself against the expected sample output shown in your copy (and below).
- Submit below — Share → "anyone with the link, Viewer", paste the link. Your sheet is graded against 2 hidden datasets, so hardcoded answers won't survive.
Sample
Input (Input!A1:B11)
| Author | Note |
| Frank | Found a hammer, Played with a pencil, Bought a new pencil |
| Alice | Found a puzzle, Bought a new basket |
| Dave | Borrowed a hammer, Showed off a puzzle, Borrowed a puzzle |
| Bob | Showed off a toy |
| Dave | Dropped off puzzle |
| Erin | Dropped off basket, Borrowed a basket |
Expected output (Answer!A2:B40)
| Author | Note |
|---|---|
| Frank | Found a hammer |
| Played with a pencil | |
| Bought a new pencil | |
| Alice | Found a puzzle |
| Bought a new basket | |
| Dave | Borrowed a hammer |
| Showed off a puzzle | |
| Borrowed a puzzle | |
| Bob | Showed off a toy |
| Dave | Dropped off puzzle |
| Erin | Dropped off basket |
| Borrowed a basket |
Adapted from "Multiline Notes" in the astral.cafe Community Practice Problems sheet.