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 functi...
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.