Using CrossTable to get Columns name

[eduardo_dimperio]

Hi,

How can I get this output, please?

Input:

Date	Consumo
28/07	0,62
28/07	0,31
29/07	0,70
29/07	0,72

Output:

28/07	29/07
0.62	0.70
0.31	0.72

Thank You

[sunny_talwar]

Try this

Table:
LOAD *,
	 AutoNumber(RecNo(), Date) as SNo;
LOAD * INLINE [
    Date, Consumo
    28/07, 0.62
    28/07, 0.31
    29/07, 0.70
    29/07, 0.72
];

FinalTable:
LOAD Distinct SNo
Resident Table;

FOR i = 1 to FieldValueCount('Date')

	LET vDate = FieldValue('Date', $(i));
	
	Left Join (FinalTable)
	LOAD SNo,
		 Consumo as [$(vDate)]
	Resident Table
	Where Date = '$(vDate)';
	
NEXT

DROP Table Table;

[Almen · Accepted solution]

You could try loading your data using Generic LOAD in the Script.

Table 1:

Generic LOAD 

Date,

Consumo

From YourDataSource;

[eduardo_dimperio]

Just Perfect.

Thank You