cross files

[pkalva]

Hi,

There is excel file with values as in cross tab see source below( iconverted to txt file)

A B C
1 4 7
2 5 8
3 6 9

In the ouput i need like


A
1
2
3
B
4
5
6
C
7
8
9


Can you help to generate the required out put.

[jvmerc]

have you tried reading the Excel file with a map? refer to the the functions guide if available on your version. Or research function ddequery.

[pkalva]

[quote="jvmerc"]have you tried reading the Excel file with a map? refer to the the functions guide if available on your version. Or research function ddequery.[/quote]

thanks jvmerc,

i saved as .csv and using few of the index functions. it worked.