I am recreating a table that utilized many merged cells (excel) but in reality, this was an offensive creation that goes against most, if not all, rules for formatting tables. Can anyone suggest alternative layouts to this method of grouping cells?

\begin{table}[htbp]\footnotesize
\centering
\caption{Add caption}
\begin{tabular}{cccrrr}
\toprule
\multirow{6}[1]{*}{\begin{sideways}40\% of index\end{sideways}} & \multirow{6}[1]{*}{\begin{sideways}\textbf{Exposure Index}\end{sideways}}
& 30\% & \multicolumn{3}{l}{Surface temperature} \\
& & 10\% & \multicolumn{3}{l}{Access to Green Space} \\
& & 10\% & \multicolumn{3}{l}{Tree Canopy Shading} \\
& & 18\% & \multicolumn{3}{l}{Dwellings in high rises (>5 storeys)} \\
& & 18\% & \multicolumn{3}{l}{Rented dwellings in older high-rises (after 1986)} \\
& & 15\% & \multicolumn{3}{l}{Population density} \\
\cmidrule{1-6}
\multirow{24}[3]{*}{\begin{sideways}60\% of index\end{sideways}} & \multirow{24}[3]{*}{\begin{sideways}\textbf{Sensitivity Index}\end{sideways}} & 25\% & \multicolumn{3}{l}{Low income persons (2005, after tax LICO)} \\
& & 5\% & \multicolumn{3}{l}{Low income persons among children (aged 0-5)} \\
& & 5\% & \multicolumn{3}{l}{Renter Household Spending >=50\% of income on housing} \\
& & 5\% & \multicolumn{3}{l}{Low-income renters spending >=50\% of income on housing} \\
& & 10\% & \multicolumn{3}{l}{Persons not speaking English} \\
& & 5\% & \multicolumn{3}{l}{Recent immigrants (2001-2006)} \\
& & 5\% & \multicolumn{3}{l}{No high school certificate among adults (aged 25+)} \\
& & 5\% & \multicolumn{3}{l}{Racialized groups} \\
& & 10\% & \multicolumn{3}{l}{Disability among persons age 25-64} \\
& & 5\% & \multicolumn{3}{l}{Emergency visits 2004-2008 for circulatory disease (age standardized rate)} \\
& & 5\% & \multicolumn{3}{l}{Emergency visits 2004-2008 for respiratory disease (age standardized rate)} \\
\cmidrule{3-6}
& & \multirow{13}[1]{*}{15\%} & \multicolumn{1}{c}{\multirow{13}[1]{*}{\begin{sideways}\textbf{Senior Sensitivity Index}\end{sideways}}} & \multicolumn{1}{c}{10\%} & Frail seniors (age 75+ with a disability) among total population in private households \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{10\%} & Low income (2005, after tax LICO) and living alone among seniors (age 65+) \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{20\%} & Low income among seniors \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{10\%} & Low income among seniors living alone \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{5\%} & Senior families paying >= 30\% on housing \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{5\%} & Unattached seniors paying >= 30\% on housing \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{10\%} & Seniors not speaking English \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{5\%} & Recent immigrants (1996-2006) among seniors \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{5\%} & No high school certificate among seniors \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{5\%} & Seniors in racialized groups \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{5\%} & Unattached seniors with disability \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{5\%} & Disability among persons age 65-74 \\
& & & \multicolumn{1}{c}{} & \multicolumn{1}{c}{5\%} & Emergency visits 2004/05 among persons age 65-74 \\
\bottomrule
\end{tabular}%
\label{tab:addlabel}%
\end{table}%


