Forum Discussion
Better support for Crosstab in Excel
This may be a sweeping statement but most data in Excel is stored as CrossTab, and not as a basic table (unless an export from another system).
It seems all LLMs including CoPilot can only function off Tabular structure and not CrossTabs, so unpivoted is a must before you can leverage CoPilot.
My wish would be that Excel supports the CrossTab structure more formally like it does with Excel Table. This will allow CoPilot to seamlessly read crosstab data without the need of the time intensive task of using Power Query to unpivot the data. This is also radically improve import of spreadsheets into Power BI!
Thoughts folks?
- Power Query is a robust tool for transforming data, including unpivoting crosstab data to a tabular format. Though it may seem time-consuming, it offers powerful capabilities for data transformation.For some tasks, Excel functions or VBA macros can be used to convert crosstab data into a tabular format. This can automate the unpivot process but may require custom development.
