Search results

Well sorry, tried pasting the Excel output and it showed in preview well but didn't show in forum. Hoping from my original type and visualizing spaces where the forum output didn't allow one might still see a solution.

hmm typing those outputs as text didn't come out right, here is the Excel Sheet different RegID's but the jist of it is the same. RegIDSem100Sem100EvalCeValueCeCreditSem200Sem200EvalCeValueCeCredit10019.01amy11 y1010029.02amy112:01pmy111003 y102:02pmy111004 y102:00pmy111005...

Hello, Not sure if this is all to be solved in Access or can be solved in Excel, but since it has to end up on a Worksheet figure this is the forum to post. Trying to transform data I get out of Access data with 4 fields RegID, SeminarNo, AttendTime, EvalComplete into an Excel like pivot...