Trying to add subfields

[#1]

I have attached a excel file. I want 5 subfields under a field. Please suggest what kind of approach should be applied.

[#2]

Look at CrossTable in the help file. You will have to indicate how many qualifier fields you have and then it will transform your load so all subsequent fields get captured as 1 field

example:

Sales:

LOAD * INLINE [

Product,Jan, Feb, Mar, Apr

a,1,2,3,4

b,2,3,4,5

c,3,4,5,6

d,4,5,6,7];

DataFinal:

Crosstable (Month,Sales,1)

LOAD *

RESIDENT Sales;

Cheers,

Byron