I did some more digging and got it to work, but not after going through the scenic route... I had to number the rows for each pyEventID. So if pyEventID...

Yes. That is exactly what is needed.

No worries...I am going home myself to be with the kids and family...will check back on tomorrow...have a great night.

Here is the additional information that you requested....This is of a more realistic input with having two different EventIDs with both having multiple "interactions" with different Companies. Let me know...

My apologies for any confusion, again this area of SQL is new to me and I feel as if my brain is short circuiting...I actually do need a cross tab...

I am working off of a view, that has a huge amount of columns...for the data I need here is the structure information

pyEventID = (Varchar (255), null)

ProviderName = (varchar(64), null)

ProviderNumber...

Here is my attemp at the Cross Tab and I am getting invalid column with the underline being on all of the Selects in the "WITH" section. I am doing...

Also thank you for the reading material on the posting rules...

Thank you for the welcome...For the I-##### in the code, can I replace this with the column name, etc.?

i.e. select eventID, P_Num, 1, 'Company', 1 union all

EventId...