I have a CSV file showing Bus Stop Codes in one column and Bus Route Numbers in another column.
As you can see there are multiple Bus Stop Codes for each Route..
I want to create a table which shows the following
I am very new to FME and only learning the basics. Is there an easy way to do this in FME for all the Bus Stop Codes ??
I've attached an example CSV file
James