Cross Table

[psk180590]

Hello All,

I have a Excel Table in the below Format, and i would like to Convert this and save the Dates as a Seperate Column.

I know about Cross Table but, somehow struggling to get the Dates from this format. Attaching sample data and app.

TIA!!

[sunny_talwar · Accepted solution]

Try this

Table:

CrossTable(Date, Quantity)

LOAD F1 as Material,

    [01.2016],

    [02.2016],

    [03.2016],

    [04.2016],

    [05.2016],

    [06.2016],

    [07.2016],

    [08.2016],

    [09.2016],

    [10.2016],

    [11.2016],

    [12.2016],

    [01.2017],

    [02.2017],

    [03.2017],

    [04.2017],

    [05.2017],

    [06.2017],

    [07.2017],

    [08.2017],

    [09.2017],

    [10.2017],

    [11.2017],

    [12.2017],

    [01.2018]

FROM

Quantity.xlsx

(ooxml, embedded labels, table is DF_GRID_1)

Where F1 <> 'Material';

FinalTable:

NoConcatenate

LOAD Material,

Date#(Date, 'MM.YYYY') as Date,

Quantity

Resident Table;

DROP Table Table;