Suppose I have the following table:
\begin{table}[!p]
\fontsize{6}{6}\selectfont
\caption{First 200 terms of Hofstadter's $Q(n)$}\label{tab11}
\center{
\begin{tabular}{l r r r r r l r r r r r}
\hline
{}&{}&{}&$n$&{}&{}&{}&{}&{}&$n$&{}&{}\\
\cline{2-6}\cline{8-12}
{}&1&2&3&4&5&{}&1&2&3&4&5\\
\hline
$Q(n+0)$&1&1&2&3&3&$Q(n+100)$&48&54&54&50&60\\
$Q(n+5)$&4&5&5&6&6&$Q(n+105)$&52&54&58&60&53\\
$Q(n+10)$&6&8&8&8&10&$Q(n+110)$&60&60&52&62&66\\
$Q(n+15)$&9&10&11&11&12&$Q(n+115)$&55&62&68&62&58\\
$Q(n+20)$&12&12&12&16&14&$Q(n+120)$&72&58&61&78&57\\
$Q(n+25)$&14&16&16&16&16&$Q(n+125)$&71&68&64&63&73\\
$Q(n+30)$&20&17&17&20&21&$Q(n+130)$&63&71&72&72&80\\
$Q(n+35)$&19&20&22&21&22&$Q(n+135)$&61&71&77&65&80\\
$Q(n+40)$&23&23&24&24&24&$Q(n+140)$&71&69&77&75&73\\
$Q(n+45)$&24&24&32&24&25&$Q(n+145)$&77&79&76&80&79\\
$Q(n+50)$&30&28&26&30&30&$Q(n+150)$&75&82&77&80&80\\
$Q(n+55)$&28&32&30&32&32&$Q(n+155)$&78&83&83&78&85\\
$Q(n+60)$&32&32&40&33&31&$Q(n+160)$&82&85&84&84&88\\
$Q(n+65)$&38&35&33&39&40&$Q(n+165)$&83&87&88&87&86\\
$Q(n+70)$&37&38&40&39&40&$Q(n+170)$&90&88&87&92&90\\
$Q(n+75)$&39&42&40&41&43&$Q(n+175)$&91&92&92&94&92\\
$Q(n+80)$&44&43&43&46&44&$Q(n+180)$&93&94&94&96&94\\
$Q(n+85)$&45&47&47&46&48&$Q(n+185)$&96&96&96&96&96\\
$Q(n+90)$&48&48&48&48&48&$Q(n+190)$&96&128&72&96&115\\
$Q(n+95)$&64&41&52&54&56&$Q(n+195)$&100&84&114&110&93\\
\hline
\end{tabular}
}
Is there a way to take this table and make it so that only one number of the sequence occurs on each line? Better yet, is there a way to take two columns from an excel file (a counting column and a column containing terms of the recursion) and transform them to a LaTeX friendly format? Are there programs that do this? Thanks!
Edit: In essence it should be two columns and, say, 31 rows including headers. The exact number of rows is something I haven't actually decided on. The idea is there would be a left column, n, and a right column Q(n) so that it would look something like:
n Q(n)
1 1
2 1
3 2
4 3
5 3
6 4
7 5
Where the values for Q(n) are the same as the values above.
vlookup
to get what you want: I've posted an example Excel file here