How can insert selected rows into an array.

Iron Contributor


I create a Pivot Table and then using array formula to get an array. I would like to insert the highlighted rows into the array. The expected result as below image:


Can you give me some advices.

Thank you.


2 Replies


Add columns and rows to a table

One quick way to add rows and columns to a table is to use the mini toolbar that opens when you're in a table. If you have a mouse, another option is to use Insert Controls.

More information you will find in the upper link.



Hope I was able to help you with this information.



I know I don't know anything (Socrates)



If data is added the table, I need to calculate more subtotals.Otherwise, it can be from other independent source. if so, maybe the data must be edited from Power Query. I use Pivot Table because it will be easier for me and other reason, everyone at my places, has been reading that report everyday and for a long time ago.Thank you for helps anyway.