Problem with wrapping of text when using longtable, multicolumn and multirow

Question

\begin{longtable}{p{0.5cm}p{4cm}p{2cm}|p{2cm}p{2cm}|p{2cm}|}
\cline{4-6}
 &  &  & \multicolumn{3}{c|}{Percentages and averages} \\ \hline
\multicolumn{1}{|l|}{Nr.} & \multicolumn{1}{p{4cm}|}{Question Question Question Question Question Question Question Question Question Question Question Question Question} & Answers & Pulukan & Tumbak Bayuh & Denpasar \\ \hline
\multicolumn{1}{|l|}{\multirow{2}{*}{23}} & \multicolumn{1}{p{4cm}|}{\multirow{2}{*}{Do you know of any organizations that can collect plastic from you? Do you know of any organizations that can collect plastic from you?}} & Yes & \% & \% & \% \\ \cline{3-6} 
\multicolumn{1}{|l|}{} & \multicolumn{1}{l|}{} & No & \% & \% & \% \\ \hline
\end{longtable}

Does anybody know how to solve this problem? Thank you in advance!

Answer 1

Here is away to do it with a simpler code: I use the xltabular environment, which brings the functionalities of longtable to tabularx, so the longtable does not overflows into the margin. I added cellspace , which defines a minimal vertical padding in cells of columns with specifier prefixed with the letter S(or C if you load siunitx).

\documentclass{article}
\usepackage{ragged2e}
\usepackage{xltabular}
\usepackage{longtable}
\usepackage{array, multirow, bigstrut, cellspace}
\setlength{\cellspacetoplimit}{3pt}
\setlength{\cellspacebottomlimit}{3pt}
\addparagraphcolumntypes{X}

\begin{document}

\setlength{\tabcolsep}{4pt}
\setlength{\bigstrutjot}{6.2ex}
 \begin{xltabular}{\linewidth}{|Sl>{\hsize=1.6\hsize\RaggedRight}S{X}|Sl|*{3}{>{\hsize=0.8\hsize\arraybackslash}X|}}
\cline{4-6}
  \multicolumn{3}{c|}{} & \multicolumn{3}{Sc|}{Percentages and averages} \\ \hline
Nr. & Question Question Question Question Question Question Question Question Question Question Question Question Question & Answers & Pulukan & Tumbak Bayuh & Denpasar \\ \hline
23 & \smash{\parbox[t]{\hsize}{Do you know of any organizations that can collect plastic from you? Do you know of any organizations that can collect plastic from you?}} & Yes \bigstrut[b] & \% & \% & \% \\ \cline{3-6}
& & No \bigstrut[b] & \% & \% & \% \\ \hline
\end{xltabular}

\end{document} 

Answer 2

Here are three more suggestions:

\documentclass{article}
\usepackage{geometry}
\usepackage{longtable}
\usepackage{pdflscape}
\usepackage{multirow}
\usepackage{xltabular}
\usepackage{makecell}
\renewcommand{\theadfont}{\normalsize}
\usepackage{booktabs}
\begin{document}

\begin{longtable}{|l|p{4cm}|l|l|l|l|}
\cline{4-6}
\multicolumn{1}{l}{} & \multicolumn{1}{l}{} &  & \multicolumn{3}{c|}{Percentages and averages} \\ \hline
Nr. & Question Question Question Question Question Question Question Question Question Question Question Question Question & Answers & Pulukan & Tumbak Bayuh & Denpasar \\ \hline
\multirow{2}{*}{23} & \multirow{6}{=}{Do you know of any organizations that can collect plastic from you? Do you know of any organizations that can collect plastic from you?} & Yes & \% & \% & \% \\ 
 & & & & & \\
 & & & & & \\ \cline{3-6}
 & & No & \% & \% & \% \\ 
 & & & & & \\
 & & & & & \\ \hline
\end{longtable}


\begin{landscape}
\begin{xltabular}{\linewidth}{|l|X|l|l|l|l|}
\cline{4-6}
\multicolumn{1}{l}{} & \multicolumn{1}{l}{} &  & \multicolumn{3}{c|}{Percentages and averages} \\ \hline
\thead{Nr.} & \thead{Question} & \thead{Answers} & \thead{Pulukan} & \thead{Tumbak\\ Bayuh} & \thead{Denpasar} \\ \hline
\multirow{2}{*}{23} & \multirow{2}{=}{Do you know of any organizations that can collect plastic from you? Do you know of any organizations that can collect plastic from you?} & Yes & \% & \% & \% \\\cline{3-6}
 & & No & \% & \% & \% \\ \hline
\end{xltabular}

\begin{xltabular}{\linewidth}{lXllll}
\toprule
\multicolumn{1}{l}{} & \multicolumn{1}{l}{} &  & \multicolumn{3}{c}{Percentages and averages} \\ \cmidrule{4-6} 
\thead{Nr.} & \thead{Question} & \thead{Answers} & \thead{Pulukan} & \thead{Tumbak\\ Bayuh} & \thead{Denpasar} \\ 
\midrule
\multirow{2}{*}{23} & \multirow{2}{=}{Do you know of any organizations that can collect plastic from you? Do you know of any organizations that can collect plastic from you?} & Yes & \% & \% & \% \\
 & & No & \% & \% & \% \\ \bottomrule
\end{xltabular}
\end{landscape}
\end{document}