Wiggly lines, which cost £1.5m, are to be removed after confusing road users.