Formulas: Sorting pivot data based on simple logic

[Andrew4119]

I'm currently trying to sort 2 variables nested in a pivot based on certain arguments.
TL;DR for some context:
(Image best explains) https://i.stack.imgur.com/HKAV3.png
L is pivot; N is desired output

1. Sheet with Codes and Names attached to them - All codes have Len=4
2. Codes can be unique and have only one name attached to them. In that case I want to sort the Code-Name as being "Single"
3. Names do repeat themselves and are not individual to codes
4. A code with different multiple Names needs to be sorted as "Multiple"
5. A code with identical multiple Names needs to be sorted as "Single"
6. I have used a & and Countif to address duplicate names with a uniqued identifier

At the moment I'm quite stuck and unsure how to proceed. Based on the logic i tried<code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; background-color: rgb(239, 240, 241); white-space: pre-wrap;">=IF(LEN(A4)=4,A4,IF(AND(OR(LEN(A3)=4,OR(LEFT(A4,10)=LEFT(A3,10),LEFT(A4,10)=LEFT(A5,10))),OR((LEN(A5)=4),A5="")),"Single","Multiple"))</code> output fails to return Single/Multiple when bullet 5.
Hope I gave enough insight. Any idea would help.
Thank you