I would like to thank Leonid for uploading a new version of CLAN that solved the problem. The following worked beautifully:<div><br></div><div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><div>---------- Forwarded message ----------</div>
<div>From: Leonid Spektor <<a href="mailto:spektor@andrew.cmu.edu">spektor@andrew.cmu.edu</a>></div><div>Date: Tue, Apr 24, 2012 at 6:02 PM</div><div>Subject: Re: +d2 to columns not rows</div><div>To: Jocelyn Marzan <<a href="mailto:jcbmarzan@post.upm.edu.ph">jcbmarzan@post.upm.edu.ph</a>></div>
<div><br></div><div><br></div><div>Joyce,</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Command "spreadsheet stat.frq.xls" create a new Excel file called "stat.frq.spread.xls". That is the file you need to open with your Excel 2002 application.</div>
<div><br></div><div>Leonid.</div></div></blockquote><div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div style="word-wrap:break-word"><br></div></blockquote><div><font face="Arial"><div>Joyce M </div>
<div>---------------------------------------<font color="#666666">---------------------</font><img src="https://lh5.googleusercontent.com/-E_hgfdOstGg/TxDiX5FdZNI/AAAAAAAAAAY/ZwXk3uH4yCY/s128/50th%252520logo%2525203x3size.png" width="96" height="89"><span style="color:rgb(102,102,102)"></span></div>
<div><font color="#666666">JOCELYN MARZAN, MA, CCC-SLP</font></div><div style="color:rgb(102,102,102)">Associate Professor</div><div style="color:rgb(102,102,102)">Department of Speech Pathology</div><div style="color:rgb(102,102,102)">
College of Allied Medical Professions</div><div style="color:rgb(102,102,102)">University of the Philippines Manila</div><div style="color:rgb(102,102,102)">UP Manila Compound, Pedro Gil Street, </div><div style="color:rgb(102,102,102)">
Malate, Manila 1004, Philippines </div><div style="color:rgb(102,102,102)"><br></div><div style="color:rgb(102,102,102)">Phone: (632) 5267125</div><div style="color:rgb(102,102,102)">Telefax: (632) 5262271</div></font></div>
<p></p>
<p></p><p></p><p></p><div><div style="display:inline"></div><div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%"></div></div>
<br>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Apr 24, 2012 at 1:23 AM, Leonid Spektor <span dir="ltr"><<a href="mailto:spektor@andrew.cmu.edu" target="_blank">spektor@andrew.cmu.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Joyce,<div><br></div><div><span style="white-space:pre-wrap"> </span>CLAN will have a SPREADSHEET command by the end of today, that will rotate any CLAN spreadsheet output on its side, turning columns into row and vice versa.<br>
<div>
<div style="word-wrap:break-word"><span style="text-indent:0px;letter-spacing:normal;font-variant:normal;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:'Lucida Grande';word-spacing:0px"><div style="word-wrap:break-word">
<span style="text-indent:0px;letter-spacing:normal;font-variant:normal;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><span style="text-indent:0px;letter-spacing:normal;font-variant:normal;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><div style="word-wrap:break-word">
<span style="text-indent:0px;letter-spacing:normal;font-variant:normal;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><div style="word-wrap:break-word">
<div><br>Leonid.</div><div><br></div></div></span></div></span></span></div></span></div><br>
</div>
<br><div><div><div class="h5"><div>On Apr 22, 2012, at 22:42 , Joyce Marzan wrote:</div><br></div></div><blockquote type="cite"><div><div class="h5">Hi! <div><br></div><div>am now integrating lexical data across CHAT files... want to come up with a "LEXICON x AGE" table extracted from 10-15 CHAT files... the "freq +d2 +t*CHI *.cha" does this beautifully, but it outputs the lexical items in columns. I am afraid I am using MS Excel 2002 which has a maximum of
<span style="background-color:rgb(239,239,239);font-family:verdana,geneva,lucida,'lucida grande',arial,helvetica,sans-serif">256 columns, but </span><span style="background-color:rgb(239,239,239);font-family:verdana,geneva,lucida,'lucida grande',arial,helvetica,sans-serif">65536 rows... is there a way to get the lexical data in rows instead of columns? attached is the output file (kindly ignore other issues... i realize i need my team to fix our headers... :-)</span></div>
<div><font color="#000000" face="verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif"><br></font></div><div><font color="#000000" face="verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif">Thank you!</font></div>
<div><font color="#000000" face="verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif"><br></font></div><div><font color="#000000" face="verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif">Joyce<br>
</font><div><font color="#000000" face="verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif"><br></font></div></div><div><br></div>
-- <br>
You received this message because you are subscribed to the Google Groups "chibolts" group.<br>
To view this discussion on the web visit <a href="https://groups.google.com/d/msg/chibolts/-/ArYyefv1DgIJ" target="_blank">https://groups.google.com/d/msg/chibolts/-/ArYyefv1DgIJ</a>.<br>
To post to this group, send email to <a href="mailto:chibolts@googlegroups.com" target="_blank">chibolts@googlegroups.com</a>.<br>
To unsubscribe from this group, send email to <a href="mailto:chibolts+unsubscribe@googlegroups.com" target="_blank">chibolts+unsubscribe@googlegroups.com</a>.<br>
For more options, visit this group at <a href="http://groups.google.com/group/chibolts?hl=en" target="_blank">http://groups.google.com/group/chibolts?hl=en</a>.<br>
</div></div><span><stat.frq.xls></span></blockquote></div><br></div></div><div class="im HOEnZb">
<p></p>
-- <br>
You received this message because you are subscribed to the Google Groups "chibolts" group.<br></div><div class="HOEnZb"><div class="h5">
To post to this group, send email to <a href="mailto:chibolts@googlegroups.com" target="_blank">chibolts@googlegroups.com</a>.<br>
To unsubscribe from this group, send email to <a href="mailto:chibolts%2Bunsubscribe@googlegroups.com" target="_blank">chibolts+unsubscribe@googlegroups.com</a>.<br>
For more options, visit this group at <a href="http://groups.google.com/group/chibolts?hl=en" target="_blank">http://groups.google.com/group/chibolts?hl=en</a>.<br>
</div></div></blockquote></div><br></div></div></div>
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups "chibolts" group.<br />
To post to this group, send email to chibolts@googlegroups.com.<br />
To unsubscribe from this group, send email to chibolts+unsubscribe@googlegroups.com.<br />
For more options, visit this group at http://groups.google.com/group/chibolts?hl=en.<br />