Need help with consolidating and arranging data.

Hi,

I am facing an interesting Excel 2010 issue which only becomes worse in the dim light of my poor Excel skills. I have no skill with VBA either, so please bear with me. Here is the problem I am working with:

1. I have a regularly updating data source which exports into two separate .csv files. After some struggle, I was able to figure out how to turn those .cvs files into one .xlsx file with two sheets. The data on both sheets is related by an ID number, but the ID number is categorized with a different title in each individual sheet. Here is an example:

Sheet 1
PrimaryID
1
2
3
4
5

Sheet 2
RefID
1
2
3
4
5

2. On almost every occasion, there are multiple rows related to the "ID" field in Sheet 1. There is also no specific set of "service types" (well there is a set of about 30 of them which I am happy to plug into a formula or sheet template, if that s what I need to do), so the data in and related to the "Service" Column changes. Example attached here example.xlsx.

My goal is to consolidate the data from both sheets into a third sheet, further consolidate the duplicate ID information into single line (creating new columns for each multiple item, displaying the Notes below each service, and applying a unique qty/rate for each new "Service" column created), and preferably automate the process as I will be populating Sheet 1 and 2 with new data daily. I added an estimate of what Sheet 3 may look like to my attachment.

The greater issue is that I am attempting to use sheet 3 as a daily MS Access update file. I assumed it would be less messy to arrange the data before it got to Access, but if there is a better way to do it in Access, I am also excited to hear about those options.

After about 16 hours of searching google, forums, and youtube, I am at a complete loss. I'm sure not knowing how to word my search has much to do with that though. Any help anyone is willing to spare is appreciated. I apologize for my lack of knowledge It seems like a big task to me, but after doing so much reading, it also seems like there may be a relatively straightforward formula or macro.

Thank you for taking the time to read,

=)