FREQ outputs in long format

[Mits Ota]

Dear chilbolts,

Does anyone know how to send out FREQ outputs in a long spreadsheet format? 
By default, spreadsheet outputs of FREQ come out in a wide format with 
speakers in rows but words across columns, like this:

     apple  banana coconut
MOT    4       3      0
FAT     2       0      19
    
I would like to obtain spreadsheet outputs for FREQ in which each row is a 
unique entry defined by the filename, speaker, word, and its frequency 
(like KWAL spreadsheet output):

File  Code  Word  Count
abc01 MOT   apple    4
abc01 MOT   banana   3
abc01 FAT   apple    2
abc01 FAT   coconut  19

Any advice is welcome! Thanks.

Mits Ota

-- 
You received this message because you are subscribed to the Google Groups "chibolts" group.
To unsubscribe from this group and stop receiving emails from it, send an email to chibolts+unsubscribe at googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/150b8a14-d78d-458e-9633-4b159c23229dn%40googlegroups.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20230908/ccfdcad8/attachment.htm>