try with CrossTable(). For example:
CrossTable(Month, Amount, 2)
(ooxml, embedded labels, table is Sheet2);
I have the next situations and it is that the data I received have combined the year 2011 and 2012 in one file for example:
Is similar to the data above but adding the columns of year 2011 for example, I try to use the Cross table but it group all columns, I tryto not include those columns but when I try use the cross table it add all the column,
I want to know if there’s a way to do a cross table for those columns separately or another way to work with this thanks.
I will appreciate your help