> ## Documentation Index
> Fetch the complete documentation index at: https://docs.qoder.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Case 11: Excel Column Expansion

## Pain Point

Excel has one-to-many columns (e.g., one contract with multiple payment batches). You need to expand to one row per batch. Usually that means complex formulas.

## After QoderWork

Describe the need in one sentence. QoderWork expands the column and outputs a new file.

## Prompt Example

```plaintext theme={null}
The "Payment batches" column has one-to-many values (comma-separated).
Expand each batch into its own row, keep other columns unchanged.
Output as a new Excel file.
```

## Key Metrics

| Metric      | Result                             |
| ----------- | ---------------------------------- |
| Simplicity  | One sentence for complex reshaping |
| No formulas | No Excel expertise needed          |
| Use case    | Common in finance and contracts    |