This is probably a question about aligning of nodes among themselves, but I hacked together this little diagram and tried to place them side by side, connected with an arrow by using offsets. There should be a better way.
\documentclass{minimal}
\usepackage{tikz}
\usetikzlibrary{shapes,arrows,calc,positioning,shapes.geometric,decorations.pathreplacing}
\tikzstyle{block} = [rectangle, draw, text width=1.8cm, text centered, minimum height=1cm]
\tikzstyle{line} = [draw, -latex']
\begin{document}
\begin{tikzpicture}
\node[block](column1) {Column 1};
\node[block, right of=column1, node distance=2.05cm](column2) {Column 2};
\node[block, right of=column2, node distance=2.05cm](column3) {Column 3};
\node[block, right of=column3, node distance=2.05cm](columnn) {Column N};
\node[block, below of=column1, node distance=1cm](value1s) {Value 1};
\node[block, below of=column2, node distance=1cm](value2s) {Value 2};
\node[block, below of=column3, node distance=1cm](value3s) {...};
\node[block, below of=columnn, node distance=1cm](valuens) {Value N};
% Attempting to vertically align the nodes with a Y-shift to place the diagrams side by side
\node[block, right of=columnn, node distance=4cm, yshift=1.5104cm](column) {Column};
\node[block, below of=column, node distance=1cm](value1) {Value 1};
\node[block, below of=value1, node distance=1cm](value2) {Value 2};
\node[block, below of=value2, node distance=1cm](value3) {...};
\node[block, below of=value3, node distance=1cm](valuen) {Value N};
\draw [decorate,decoration={brace,amplitude=10pt,raise=2mm}] (value1.north east) -- (valuen.south east) node [black,midway,xshift=1.7cm,text width=1.8cm] (aggappl) {Lorem ipsum dolor};
\draw [decorate,decoration={brace,amplitude=10pt,raise=2mm,mirror}] (value1s.south west) -- (valuens.south east) node [black,midway,yshift=-1cm] (aggnoappl) {Lorem ipsum dolor};
\path [line,shorten >=2mm,shorten <=2mm] (valuens.north east) -> (value2.west);
\end{tikzpicture}
\end{document}
The steps in the arrow can be seen in the screenshot, so it is not really horizontal:


shortens are still.... – percusse Sep 07 '16 at 17:59