How do I pull the "Part Num"s over to be listed under "list" BUT only if the QTY is > 0. If the QTY is 0, then it should not be under "list". Essentially, 111,444,555,666 should all be listed ONLY. Also, I don't want any blank spaces under "list".

Is there more formula I can add to the above formula in cell A2 so it will automatically remove those blank spaces in the List column?

Need it to look like this with only formula and not filter or sort.

\begin{tabular}{|r|l|l|l|l|} \hline \multicolumn{1}{|l|}{ List } & \multicolumn{2}{|c|}{ Part Num } & \multicolumn{2}{|c|}{ QTY } \\ \hline 111 & & & 111 & 1 \\ \hline 444 & & & 222 & 0 \\ \hline 555 & & & 333 & 0 \\ \hline 666 & & & 444 & 4 \\ \hline & & & 555 & 5 \\ \hline & & & 666 & 1 \\ \hline \end{tabular}