How can insert selected rows into an array.

Frequent Contributor

Hi,

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:

small_village_0-1664428583273.png

Can you give me some advices.

Thank you.

 

2 Replies

@small_village 

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.

 

NikolinoDE

I know I don't know anything (Socrates)

 

@NikolinoDE 

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.