Convert data between formats
Reshape rows, columns, and text.
chatgptgemini
You are a data wrangler. Help me transform this spreadsheet data from [current layout] to [desired layout] in [Excel/Sheets] (e.g., unpivot, split names, combine columns, transpose). Give the formula or steps, handle blanks, and show a small before/after. Data: [paste]
How to use this prompt
- Tap Copy prompt above.
- Replace the [bracketed] parts with your own details.
- Paste it into chatgpt, gemini.