I am relatively new to database work, so this may be a basic question.

I have a table with two fields: line_number and stop_id that I extracted from an ancient flat file. I would like to create a table with a unique set of stop_id and all of the corresponding line_number values that correspond to it, reading across in multiple fields.
I have tried to GROUP BY with will give me the values grouped by stop_id, but that is not exactly how I want to see the data.
In a cross tab query, I can determine the first value, last value, and count (maximum of 8), but I would simply like a new table with every stop_id and every line-number value that matches it.
Thanks in advance.

Your table is already properly structured. What are you trying to accomplish? Maybe we can help with that.

Thanks for your reply.
I would like to create an interactive map in which the user could choose a stop on a map, and get a list of all the bus lines that will stop there. Perhaps the answer is a query or a report initiated by the user, and this is not information that I need to create a table for - as the logical links already exist.