Power Pivot Table to Excel Question

[gmazza76]

Good afternoon,

I have a table in Power Pivot that I need to be visible as it is in Excel, but when I connect via

Data - Existing Connection - Table
I select as "Table" and "New worksheet", the data drops in, but not in the column position as it is in Power Pivot.

As in the wrong position I mean date is at the beging of the table in Power Pivot, but at the end when it drops into Excel.
IS there anyway to keep the original format or move the columns around without deleting information.

thanks in advance
Gavin

 

[Alex Blakenburg]

I am not sure what you are trying to achieve.
Power Query is your best bet for rearranging the columns and to mirror any summarisation used in the pivot table.