MainSource:

LOAD A,

     B,

     C,

     D,

     E,

     F,

     G,

     H,

     I,

     J,

     K,

     L,

     M,

     N

FROM

Crosstable_Sample.xlsx

(ooxml, no labels, header is 4 lines, table is Sheet2);

CrossTable:

LOAD

  A as AppType,

  B as AppName,

  '01/01/2015' as AppDate,

  C as Sched,

  D as Avail,

  E as AvailPct

Resident

MainSource;

Concatenate LOAD

  A as AppType,

  B as AppName,

  '01/02/2015' as AppDate,

  F as Sched,

  G as Avail,

  H as AvailPct

Resident

MainSource;

Concatenate LOAD

  A as AppType,

  B as AppName,

  '01/03/2015' as AppDate,

  I as Sched,

  J as Avail,

  K as AvailPct

Resident

MainSource;

Concatenate LOAD

  A as AppType,

  B as AppName,

  '01/04/2015' as AppDate,

  L as Sched,

  M as Avail,

  N as AvailPct

Resident

MainSource;

drop table MainSource;