# Structured-data pivot-table coding interview question

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/3535/create-function-structured-data-input-output-pivot-table
Source observed: 2026-11-05T01:45:51.041Z
Last checked: 2026-11-05T01:45:51.041+00:00
Indexed: 2026-11-07T03:32:04.365+00:00

---

# Create a function that accepts structured data as input, includes column names, and outputs data suited for generating a pivot table.

We provide this as an Aced (formerly Exponent) interview-practice question. It asks candidates to create a function that:

- Accepts structured data as input.
- Includes column names.
- Outputs data suitable for generating a pivot table.

## Question details

- **Interview type:** Technical
- **Role:** [Software Engineer](https://www.aced.io/questions?role=swe)
- **Company:** [Sigma Computing](https://www.aced.io/questions?company=Sigma%20Computing)
- **Category:** [Technical](https://www.aced.io/questions?type=technical)
- **Reported last asked:** 3 years ago
- **Community answers:** No answers have been contributed yet.

Detailed company statistics for this question are available through [Upgrade](https://www.aced.io/upgrade?src=questions). To submit an answer, log in or sign up; submitting marks the question complete.

## Related courses

### [Software Engineering Interview Prep](https://www.aced.io/courses/software-engineering)

Prepare for software engineering roles at Google, Amazon, Microsoft, Meta, Apple, and other top companies through mock interviews, frameworks, and advice from senior candidates. Practice data structures, algorithms, system design, people management, behavioral interviews, and more.

![Software Engineering Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/4VkuYewBHUFIVUS5oJDW5h/02e833439b1289f25f38f13f81cbdca3/adobe_stock_optimized.jpeg?w=800&h=800&fm=webp&q=75)

### [System Design Interviews](https://www.aced.io/courses/system-design-interviews)

Learn to answer current system design questions across product, infrastructure, and AI domains with in-depth video examples, written breakdowns, reference patterns, and mock interview videos featuring senior engineers and managers.

![System Design Interviews](https://images.ctfassets.net/x78yjrjc11pq/78x7miFZFjBCrM5GqftrMJ/2f6d26e632c4e7265c49f6a180227edb/system_design_track_compressed_26ac98a46e__281_29_5be2280f31.jpeg?w=800&h=800&fm=webp&q=75)

## Explore Aced

We offer interview preparation courses and practice resources covering Product Management, Forward Deployed Engineering, Engineering Management, Software Engineering, System Design, Data Science, Machine Learning, Data Engineering, AI Engineering, Investment Banking, Generative AI, Security Engineer, TPM, Solutions Architect, UX / Product Design, and BizOps & Strategy.

- [All questions](https://www.aced.io/questions)
- [Courses](https://www.aced.io/courses?src=nav)
- [Practice](https://www.aced.io/practice?src=nav)
- [Coaching](https://www.aced.io/coaching?src=nav)
- [Pricing](https://www.aced.io/upgrade?src=nav)
- [Log in](https://www.aced.io/login?src=nav)
- [Sign up](https://www.aced.io/signup?src=nav)

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3535%2Fcreate-function-structured-data-input-output-pivot-table&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3535%2Fcreate-function-structured-data-input-output-pivot-table). Opening a form does not execute a tool.