Date Column Help

[#1]

Hi

I have the following Data Example, but I can’t find a way to group the date so it can be manage in QV, because it's separete ..

Name	Service Name	01/01/12	02/01/12	03/01/12	04/01/12	05/01/12	06/01/12	07/01/12	08/01/12	09/01/12	10/01/12	11/01/12	12/01/12	TOTAL 2012
company	Service	1,073	1,073	1,073	1,073	1,073	1,073	1,073	1,073	3,889	2,816	3,119	3,119	21,527
Company 2	Service 2	7,271	7,271	7,271	7,271	7,271	7,271	7,271	7,271	908	908	943	943	61,866
Company 3	Services 3									1,940	1,940	2,425	2,425	8,730

if you can see all Month are in different column, I want to know if there’sa way to group or work with this.

let me know if need more info ..

Thanks

[#2 · Accepted solution]

try with CrossTable(). For example:

Directory;

CrossTable(Month, Amount, 2)

LOAD Name,

     [Service Name],

     [01/01/2012],

     [02/01/2012],

     [03/01/2012],

     [04/01/2012],

     [05/01/2012],

     [06/01/2012],

     [07/01/2012],

     [08/01/2012],

     [09/01/2012],

     [10/01/2012],

     [11/01/2012],

     [12/01/2012],

     [TOTAL 2012]

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet2);

[#3]

Thanks For your help!! 

[#4]

Hi,

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