Firstly let me tell you I have tried for hours to work out how to do this and am very hopeful to lend on the brainstrust here for a solution.
Attached is the current and desired outlay of data I am currently working with. I can get rid of unnecessary columns etc. but struggling to get the repeating "Job, Customer, 1000X, Total for Job into columns. Tried pivot, tranform but could not get it to work.
Job billing data.xlsx (11.2 KB)