You kind of prove my point. General population don't need to learn how to do programming, but they need to be able to take a complex problem and break it down into small steps which they can run using existing tools.
In the case of the CSV first/last name splitting, the solution was to add a column with a formula that contained the position of the first space, a second column that contained the part of the full name up to that position and a third column with the rest. This gets you ~90% of the way. Finally a single manual pass to find and fix the exceptional cases. Very little technical skill required, but saved a lot of time.
Many people don't have a software developer readily available, and even if they do, their time is often a lot more expensive. Besides, requiring two people to solve the problem
You changing your oil costs you the price of the oil plus markup, labour costs, time to make a garage appointment, drive to and from the garage, wait for them to finish and hope you didn't have to shuffle around too much of your time in order to fit in the appointment in the first place. For me it costs five minutes and the price of the oil.