Here is a solution which defines two new columns with compact lists. I pretty sure that it is based on a answer by Heiko Oberdiek, but I was not able to find the answer to give correct reference.
One column is defined as a itemize list, one is defined as a numbered list. You can change the width of the list columns at will. If you prefer that the tabular fills the space between the margin, you can use \extracolsep{\hfill}
. You may also use xltabular.
If the heading shall be repeated at each page, just use the normal longtable commands. To cancel enumeration or itemisation for individual cells, you use \multicolumn
.

\documentclass{article}
\usepackage{array, longtable, booktabs}
\makeatletter
\newcolumntype{e}[1]{%--- Enumerated cells ---
>{\minipage[t]{\linewidth}%
\NoHyper% Hyperref adds a vertical space
\let\\\tabularnewline
\settowidth{\leftmargini}{\,9.\hspace{\labelsep}}
\enumerate
\addtolength{\rightskip}{0pt plus 50pt}% for raggedright
\setlength{\itemsep}{-\parsep}}%
p{#1}%
<{\@finalstrut\@arstrutbox\endenumerate
\endNoHyper
\endminipage}}
\newcolumntype{i}[1]{%--- Itemized cells ---
>{\minipage[t]{\linewidth}%
\let\\\tabularnewline
\settowidth{\leftmargini}{~\hspace{\labelsep}}
\itemize
\addtolength{\rightskip}{0pt plus 50pt}%
\setlength{\itemsep}{-\parsep}}%
p{#1}%
<{\@finalstrut\@arstrutbox\enditemize\endminipage}}
\AtBeginDocument{%
\@ifpackageloaded{hyperref}{}%
{\let\NoHyper\relax\let\endNoHyper\relax}}
\makeatother
\setlength{\tabcolsep}{3pt}
\setlength{\extrarowheight}{2pt}
\begin{document}
\begin{longtable}{@{\extracolsep{\fill}}p{2cm}p{2cm}i{3.5cm} e{3.5cm}@{}}
\toprule
Site & Description & \multicolumn{1}{l}{Avantages} & \multicolumn{1}{l@{}}{Disavantages}\\
\midrule\endhead %% Repead heading on every page
Text here and there & More left aligned text &
\item Item A is part of a itemised list
\item Item B &
\item Item 1 is part of a numbered list
\item Item 2 \\
\midrule
Text & Text &
\item Item A
\item Item B &
\item Item 1
\item Item 2
\item Item 1
\item Item 1
\item Item 1
\item Item 1
\item Item 1
\item Item 1
\item Item 1
\item Item 1
\item Item 1
\item Item 1
\\
\bottomrule
\end{longtable}
\end{document}
description
environment (for "Site" and "Description" and a nested itemize for the advantages/disadvantages part?