Sorting pivot data based on simple IF logic

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


Sheet with Codes and Names attached to them - All codes have Len=4
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"
Names do repeat themselves and are not individual to codes
A code with different multiple Names needs to be sorted as "Multiple"
A code with identical multiple Names needs to be sorted as "Single"
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=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"))

output fails to return Single/Multiple when bullet 5.

Hope I gave enough insight. Any idea would help.

Thank you

Attach a sample Excel workbook (not a picture!). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.