I don't think Import will work in your case because Percentages are input at State Level and this has to be distributed evenly thru all the medicines - You don't have the mapping at all.
Since State and Medicine do not share the hierarchical relationship you can achieve this by creating Medicine list as a numbered list and State list being the property of the Medicine list and then use LOOKUP
From your initial diagram it looks like all Medicines belong to each state, so a module dimensioned by State and Medicine will suffice; you don't need a LOOKUP at all.
A module dimensioned by State to hold the %s and then in the target module, you can just reference the previous line item
If you have a relationship between State and Medicine, then you do need to model the relationship between State and Medicine
One of the big advantages of Anaplan is we do not always need parent child relationships to aggregate or model, as previously described. If there is only one State for any one Medicine, then you can just have a module dimensioned by Medicine and have a line item formatted as State to hold the mapping. then use a LOOKUP to the State %s module
If these concepts are difficult for you to understand, then I would suggest you take the Level 1 training, if you haven't already and also look at the attached.