# pgfplotstable, multicolumn sp

I am trying to make a table (code below) that should contain three headings and five equally spaced sub columns but the one on the far right does not want to agree. If I make the really long heading on multiple lines then all is tidy but I'd rather have a nicely spaced wide table.

\documentclass[[a4paper,12pt]{article}
\usepackage{pgfplotstable}
\usepackage{booktabs}
\begin{document}
\begin{table}
\centering
\caption{Multicolumn Table}
\pgfplotstabletypeset[
every head row/.style={after row={\toprule\toprule \multicolumn{1}{c}{C} &     \multicolumn{1}{c}{B} & \multicolumn{3}{c}{A very Long Heading On One Line}\\}},
every first row/.style={after row=\midrule},
every last row/.style={after row=\bottomrule\bottomrule},
string type,
columns/0/.style={column name=},
columns/1/.style={column name=},
columns/2/.style={column name=},
columns/3/.style={column name=},
columns/4/.style={column name=},
columns/5/.style={column name=},
columns/6/.style={column name=},
col sep=comma, row sep=\\,
string type,
]{
,,d,e,f\\
1,4,2,8,1\\
5,5,5,8,6\\
2,6,4,6,2\\
3,7,5,6,5\\
9,8,3,3,3\\
7,9,1,5,1\\
7,7,4,9,2\\
6,1,3,7,7\\
2,7,1,3,8\\
7,9,5,5,7\\
9,4,6,5,7\\
Ans,,9,9,9\\
}
\end{table}

\end{document}

• When you span columns, the excess space goes into the last one. – egreg May 23 '16 at 17:52
• Is there a way to equally distribute the space? – kljadsfnzxcviasdfnk May 24 '16 at 10:28