Manipulating Data - Fill Down

JasonWills,

Have you tried "Fill Down" when you Edit Queries - e.g. see this post: https://www.excelcampus.com/library/fill-down-blank-null-cells-power-query/

And it might help in the long run if you filter out the TOTAL rows for a cleaner data model.

JasonWillsyou are working with a Pivot Table that's in Tabular Form

Is this a 1) functional Pivot Table or has someone copied the result and given you the 2) copy?

1) If its a real functional Pivot Table you can do the steps below and then copy the result if that's what you want to import?

(don't know why you want to do this though - and not import the sources of the Pivot Table instead???)

Go Back in EXCEL => click inside the Pivot Table to get the PivotTable Tools tabs => go to the Design tab

in the Layout group of buttons on the left side of the screen => click the Report Layout button (drop-down)

select Repeat All Item Labels

The last step would be in the same group of buttons => click Subtotals button => Do Not Show Subtotals

You can do the same for Total Rows/Columns if necessary

Now you can copy the results and import

2) If this is a Copy of a Pivot Table - why don't you just click in the Cell under 2012 type 2012 again and then drag till you reach 2013. Use the Auto-Fill this way under each "Value" just type it a second time and then drag to auto-fill

And delete the subtotal and total rows (and columns if any)

Hope this helps.

Good Luck! :smileyhappy: