CrystalKim
MIS
I apologize for the vague description, it's the only way I could think of wording it.
I have an Excel spreadsheet. On this spreadsheet is City information, Year and Motor Vehicle Registration Types. The Spreadsheet looks like this. This is sample data
City Year Luxury Cars SUVs Trucks
Agawam 2000 20 50 15
1999 19 48 10
1998 21 44 18
Ware 2000 5 10 2
1999 4 8 1
1998 2 3 2
What I need to do is copy and paste the City information for the other years below them so I can put this in
Access for queries. My desired look would be this
City Year Luxury Cars SUVs Trucks
Agawam 2000 20 50 15
Agawam 1999 19 48 10
Agawam 1998 21 44 18
Ware 2000 5 10 2
Ware 1999 4 8 1
Ware 1998 2 3 2
I know I can copy and paste the info. but I have like 2000 rows of data similar to this and it would probably take me most of the day.
Does anyone know of an easier way to do this.
Thanks in advance
I have an Excel spreadsheet. On this spreadsheet is City information, Year and Motor Vehicle Registration Types. The Spreadsheet looks like this. This is sample data
City Year Luxury Cars SUVs Trucks
Agawam 2000 20 50 15
1999 19 48 10
1998 21 44 18
Ware 2000 5 10 2
1999 4 8 1
1998 2 3 2
What I need to do is copy and paste the City information for the other years below them so I can put this in
Access for queries. My desired look would be this
City Year Luxury Cars SUVs Trucks
Agawam 2000 20 50 15
Agawam 1999 19 48 10
Agawam 1998 21 44 18
Ware 2000 5 10 2
Ware 1999 4 8 1
Ware 1998 2 3 2
I know I can copy and paste the info. but I have like 2000 rows of data similar to this and it would probably take me most of the day.
Does anyone know of an easier way to do this.
Thanks in advance