Reformatting spreadsheet [convert SAP data into the desired format]

[lemonap618]

Hello All,
I hope this message finds you all well.

I have a spreadsheet (attached) that contains two tabs - one is the SAP data (SAP_EURdata) and another is the desired format (Desired template). I need help to convert the SAP data into the desired format.
If you look at the dates in the SAP_EURdata tab, you will find the dates repeat themselves once. You will find a numerical value and a text value. I need to display the numerical value for each sold to under the corresponding text for each month.
For example, sold to Matel we see there first order was 65.96 in February 208 - I would then want to put 65.96 (AJ2) under the (BT2) New Tenant column on my Desired template.

Finally, on the desired template, I only went to November 2018. If possible could you please provide data all the way to Sept 2020?

If you could provide your solution and then provide your steps you completed to resolve, that would be fantastic. Thanks!

Your help is greatly appreciated!
Thanks!
Andrew

[alansidman]

How is this request different from the one you made yesterday? It appears to be the same issue?

https://www.excelforum.com/excel-gen...readsheet.html

[lemonap618]

Hi Alansidman,
I'm happy to see you respond. I need the same file once again; however, the data I provided yesterday had major errors in it.
If possible could you rerun for me one more time? I would greatly appreciate it!

[alansidman]

I am will close this as it duplicates the original thread. Repost the Information in #1 here to your original thread and in the meantime, I will begin trying to duplicate my efforts from yesterday.