I'm trying to prepare a table that will be analyzed spatially with GIS. The table has the list of town and the different projects that are conducted in those towns. Some towns have multiple projects, others just have one. I want to create a data frame where there's one row for each town and columns for as many projects there are in that town.
Here's what I want to do:
Take this
Town Project
A 1
A 2
A 3
B 4
B 5
C 6
Town Project1, Project2, Project3
A 1 1 3
B 4 5
C 6
Please let me know if this makes sense. Thanks