Transpose a table in place
Spreadsheet manipulationEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Transpose the table in place.
Starting spreadsheet
Monthly| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Metric | Jan | Feb | Mar | Apr |
| 2 | Revenue | 120 | 135 | 148 | 162 |
| 3 | Cost | 76 | 82 | 91 | 98 |
| 4 | Profit | 44 | 53 | 57 | 64 |
A passing output
Autosheet in Excel · Opus 5.5| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit | |
| 2 | Jan | 120 | 76 | 44 | |
| 3 | Feb | 135 | 82 | 53 | |
| 4 | Mar | 148 | 91 | 57 | |
| 5 | Apr | 162 | 98 | 64 |
Excel and Sheets · All types · All models · All outputs
Pass criteria
All must be met, checked automatically.A1:D5hold the expected values
Passed 22
Autosheet in Excel Opus 5.5 · Medium
Passed15s · 3¢
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit | |
| 2 | Jan | 120 | 76 | 44 | |
| 3 | Feb | 135 | 82 | 53 | |
| 4 | Mar | 148 | 91 | 57 | |
| 5 | Apr | 162 | 98 | 64 |
Autosheet in Excel GPT-6 Astra · Low
Passed6s · 4¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Autosheet in Sheets Opus 5.5 · Medium
Passed25s · 12¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Autosheet in Excel Sonnet 5.5 · Medium
Passed7s · 1¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Claude in Excel Opus 5.5 · High
Passed8s · 11¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Autosheet in Excel Haiku 5.5 · High
Passed7s · 0.1¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Claude in Sheets Opus 5.5 · Medium
Passed33s · 14¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Claude Code + Sheets MCP Opus 5.5 · Medium
Passed33s · N/A
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Autosheet in Excel GPT-6.1 Sol · Medium
Passed18s · 2¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
Passed1m 5s · N/A
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
ChatGPT + Autosheet MCP GPT-6 · Medium
Passed45s · N/A
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Autosheet in Sheets Haiku 5.5 · High
Passed30s · 0.3¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
ChatGPT in Excel GPT-6 Astra · Medium
Passed14s · 37¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Claude in Excel Haiku 5.5 · High
Passed10s · 0.4¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Claude in Sheets Haiku 5.5 · High
Passed27s · 0.8¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Autosheet in Excel GPT-6 Luna · High
Passed10s · 0.2¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Copilot in Excel Auto
Passed21s · N/A
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
ChatGPT + Drive MCP GPT-6 · Medium
Passed35s · N/A
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
ChatGPT in Excel GPT-6 Luna · High
Passed22s · 0.4¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
Gemini in Sheets Auto
Passed1m 3s · N/A
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
ChatGPT in Sheets GPT-6 Astra · Medium
Passed23s · 32¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |
ChatGPT in Sheets GPT-6 Luna · High
Passed27s · 0.4¢
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | Revenue | Cost | Profit |
| 2 | Jan | 120 | 76 | 44 |
| 3 | Feb | 135 | 82 | 53 |
| 4 | Mar | 148 | 91 | 57 |
| 5 | Apr | 162 | 98 | 64 |