I have a REALLY badly formatted CSV file which is generated automatically by the software - the output can't be altered.
The data shows calls to a service centre. Unfortunately, instead of adding the call handlers name to a column for their calls, its added as a row before. There's then an emoty row before the details for the next handler.
I need to take this call handler name and add it to a column for their data only (ie before the next empty row). Any ideas on how to do this? This is my first step into the world of FME so I'm have in a baptism of fire...
Kind Regards,
Ned