You can rotate general material, like your whole picture, using the \rotatebox{<angle>}{<content>} macro from the standard graphicx package (already loaded by TikZ anyway), e.g. try \rotatebox{90}{\input{<filename>}}.
This looks also like a good use-case of standalone. The v1.0 version provides \includestandalone[<options, incl. angle>]{<code file, like your .pgf>}.
This also allows you to compile the picture on its own, which is very nice during its creation process.
% Visioritning2.tex
\documentclass[tikz]{standalone}
\begin{document}
\begin{tikzpicture}[scale=0.30]
\pgftext{\includegraphics{TransformerSubstationFeeding}}
\small
\node at (8,-0.5) {Ground};
\node at (-0.5,-0.5) {Ground};
\node at (-9,-0.5) {Ground};
\node at (14.5,9.1) {Public grid; phase A};
\node at (14.5,8.3) {phase A};
\node at (14.5,7.5) {phase B};
\node at (14.5,6.7) {phase C};
\node at (14.5,2.3) {Railway grid};
\node at (14.5,1.5) {catenary};
\node at (14.5,0.7) {rail/ground};
\node at (11.5,3.8) {Transformer};
\node at (3.0,3.8) {Transformer};
\node at (-5.5,3.8) {Transformer};
\end{tikzpicture}
\end{document}
% Main document
\documentclass{article}% or any other
\usepackage{tikz}
\usepackage{standalone}
\begin{document}
% ...
\begin{figure}
\centering
\includestandalone[angle=90]{Visioritning2}
\caption{A simplified illustration of how the three-phase grid commonly feeds the railway when using substation transformers}
\label{Figure:SimplifiedTransformerSubstation}
\end{figure}
% ...
\end{document}
You table is quite large and will imho take up a page anyway, so sidewaystable is probably the best solution. But you can also put the tabular and the caption in a minipage or a varwidth box and rotate this:
\documentclass[11pt,a4paper]{article}
\usepackage[graphicx]{realboxes}
\usepackage{varwidth}
\begin{document}
%% what i want
\begin{table}[htb]
\centering
\rotatebox{90}{%
\begin{varwidth}{\textheight}
\begin{tabular}{|l|c|c|c|c|c||c|c|c|c|c||c|c|c|c|c|}
\hline
\bfseries Some text & \rotatebox{90}{column 1 } & \rotatebox{90}{column 2} & \rotatebox{90}{column 3 } & \rotatebox{90}{column 4 } & \rotatebox{90}{column 5 } & \rotatebox{90}{column 6 } & \rotatebox{90}{column 7} & \rotatebox{90}{column 8 } & \rotatebox{90}{column 9 } & \rotatebox{90}{column 10 } & \rotatebox{90}{column 11 } & \rotatebox{90}{column 12} & \rotatebox{90}{column 13 } & \rotatebox{90}{column 14 } & \rotatebox{90}{column 15 }\\
\hline \hline
first row lorem ipsum & 692 & 535 & 85 & 48 & 24 & 692 & 535 & 85 & 48 & 24 & 2 & 3 & 3 & 4 & 5 \\ \hline
\end{tabular}
\caption{My caption lorem ipsum}\label{tab_b}
\end{varwidth}}
\end{table}
For the table see \ref{tab_b}
\end{document}
N.B: Don't use \bf, use \bfseries instead.
Best Answer