Pasting into spreadsheet with diferent row numbers

[crobert8]

I have been working on adding Lat/Long coordinates to an excel spreadsheet to import into another program and build XYpoints. Basically I was given a spreadsheet with over 900 potential projects and was told to get location info for each some however have multiple prject locations so I inserted rows for the additional points. Yesterday I was told that they have created an updated spreadsheet and would like me to paste my coordinates to the new sheet, however because my sheet has multiple rows for the same project I cant think of a way to paste them all at once as the rows dont match up. Any ideas or am I going to have to do it the long way? Sorry for the longwinded question I will include a snip from each sheet so you can get an idea of what Im working with.

My sheet:

Excel 2012
	A	D	F	G	H	I	K	L
1	Project Number	Project Title	County	Estimated Cost	Submitted By	Hyperlink to full proposals	x	y
2	1	Fruit Farm Creek Mangrove Restoration Project	Collier	1940000	Coastal Resources Group, Inc.	1-020213 Collier_Fruit Farm Creek	-81.655200	25.939700
3	1						-81.686600	25.924200
4	2	Enhancing Community Resiliency through Coordination and Coorperation	All	100000	Florida Emergency Preparedness Association	2-021313 Statewide_Community Resiliency
5	3	Torry Island Pond Apple Forest Restoration Project	Palm Beach	250000	Arthur R. Marshall Foundation for the Everglades	3-021313 Palm Beach_Torry Island	-80.766666	26.750000
6	4	Choctawhatchee-Pea Basin Unpaved Road-Stream Crossings Assessment and Treatment System (CATS) Demonstration Project	Bay, Holmes, Jackson, Walton, Washington	110300	Science Applications International Corporation (SAIC)	4-021813 Multiple_Choctawhatchee-Pea Basin	-86.056759	30.937767
7	4						-85.798269	30.761978
8	4						-86.354709	30.507779
9	5	Northwest Florida Borrow Pits Inventory and Assessment Project	Escambia to Jefferson Counties	131200	Science Applications International Corporation (SAIC)	5-021813 Multiple_Northwest Florida Borrow Pits	-87.455282	30.767438
10	5						-87.321924	30.484363
11	5						-87.286570	30.814356
12	5						-87.076428	30.439786
13	5						-86.946516	30.828921
14	5						-86.488556	30.776795
15	5						-86.354174	30.517923
16	5						-86.101847	30.947581
Sheet1

New Sheet:

Excel 2012
	A	B	C	D	E	F	G	H
1	Project Number	Geographic Area	Geographic Region	Confirmation No.	Project Title	Abbreviated Project Description	X	Y
2	1	Collier		1-020213	Fruit Farm Creek Mangrove Restoration Project	Total project size is 1,025 acres. The project would restore historical hydrologic connections across CR 92 in Collier County to restore 64 acres of dead mangroves, permanently prevent future immediate death of 161 acres of severely stressed mangroves, and conserve and forestall death of an additional 800 acres of mangroves until further work could be undertaken (During Phase 3 not described here). Total restored or conserved: 1,025 acres.
3	2	Statewide		2-021313	Enhancing Community Resiliency through Coordination and Coorperation	The Florida Emergency Preparedness Association (FEPA) is a statewide association of Florida emergency management professionals. Under this project, FEPA proposes to sponsor a multi-day interactive forum to discuss emergency planning and mitigation measures to improve coordination at all levels of government and the private sector to address a broad range of hazards. FEPA is unique in that it includes representatives from all response disciplines as well as key private sector partners.
4	3	Palm Beach		3-021313	Torry Island Pond Apple Forest Restoration Project	This is an ongoing project (which has been on hold due to lack of funding) to restore the Pond Apple Forest and related species that constituted the Torry Island historical habitat; The Pond Apple Forest, AKA Custard Apple, is also the habitat for the Okeechobee Gourd, an endangered species, and part of the ancient native culture.
5	4	Multiple	Bay, Holmes, Jackson, Walton, Washington	4-021813	Choctawhatchee-Pea Basin Unpaved Road-Stream Crossings Assessment and Treatment System (CATS) Demonstration Project	The proposal is that the Crossing Assessment and Treatment System (CATS) be implemented to demonstrate the uses and benefits of an innovative approach to developing treatment alternatives for maintaining unpaved road crossings. This technology utilizes resource data and on-site investigations to formalize customized solutions that offer combinations of best practices to target and cost-effectively resolve site-specific problems.
6	5	Multiple	Escambia to Jefferson Counties	5-021813	Northwest Florida Borrow Pits Inventory and Assessment Project	The anticipated deliverable for the proposed project is the Northwest Florida Borrow Pit Inventory and Assessment Map Atlas. The atlas would include:Project area natural resource and regulatory information.Overview of borrow pit types, mined materials, operations, and stormwater management.Borrow pit treatment priorities and recommendations.Borrow pit site dossiers that include geography, geology, disturbance regimes, operation and maintenance activities, stormwater features and conditions, water quality and sensitive karst index analysis results, and site photograph logs. GIS maps and database.
Sheet 1

 

[hiker95]

crobert8,

Welcome to the MrExcel forum.

Can we have two screenshots of the New Sheet:
1. the way it looks when you first receive it
2. the way it should look (manually formatted by you) for the results you are looking for

 

[crobert8]

This is how I would like it to look but with the X Y fields filled from my sheet, couldnt find an edit button for the original post so I replied it sorry for my noobness.

Excel 2012
	A	B	C	D	E	F	G	H
1	Project Number	Geographic Area	Geographic Region	Confirmation No.	Project Title	Abbreviated Project Description	X	Y
2	1	Collier		1-020213	Fruit Farm Creek Mangrove Restoration Project	Total project size is 1,025 acres. The project would restore historical hydrologic connections across CR 92 in Collier County to restore 64 acres of dead mangroves, permanently prevent future immediate death of 161 acres of severely stressed mangroves, and conserve and forestall death of an additional 800 acres of mangroves until further work could be undertaken (During Phase 3 not described here). Total restored or conserved: 1,025 acres.
3	1
4	2	Statewide		2-021313	Enhancing Community Resiliency through Coordination and Coorperation	The Florida Emergency Preparedness Association (FEPA) is a statewide association of Florida emergency management professionals. Under this project, FEPA proposes to sponsor a multi-day interactive forum to discuss emergency planning and mitigation measures to improve coordination at all levels of government and the private sector to address a broad range of hazards. FEPA is unique in that it includes representatives from all response disciplines as well as key private sector partners.
5	3	Palm Beach		3-021313	Torry Island Pond Apple Forest Restoration Project	This is an ongoing project (which has been on hold due to lack of funding) to restore the Pond Apple Forest and related species that constituted the Torry Island historical habitat; The Pond Apple Forest, AKA Custard Apple, is also the habitat for the Okeechobee Gourd, an endangered species, and part of the ancient native culture.
6	4	Multiple	Bay, Holmes, Jackson, Walton, Washington	4-021813	Choctawhatchee-Pea Basin Unpaved Road-Stream Crossings Assessment and Treatment System (CATS) Demonstration Project	The proposal is that the Crossing Assessment and Treatment System (CATS) be implemented to demonstrate the uses and benefits of an innovative approach to developing treatment alternatives for maintaining unpaved road crossings. This technology utilizes resource data and on-site investigations to formalize customized solutions that offer combinations of best practices to target and cost-effectively resolve site-specific problems.
7	4
8	4
9	5	Multiple	Escambia to Jefferson Counties	5-021813	Northwest Florida Borrow Pits Inventory and Assessment Project	The anticipated deliverable for the proposed project is the Northwest Florida Borrow Pit Inventory and Assessment Map Atlas. The atlas would include:Project area natural resource and regulatory information.Overview of borrow pit types, mined materials, operations, and stormwater management.Borrow pit treatment priorities and recommendations.Borrow pit site dossiers that include geography, geology, disturbance regimes, operation and maintenance activities, stormwater features and conditions, water quality and sensitive karst index analysis results, and site photograph logs. GIS maps and database.
10	5
11	5
12	5
13	5
14	5
15	5
16	5
17	6	Multiple	Gulf, Bay, throughout Gulf of Mexico oceanic and neritic habitat	6-022013	Spatial ecology and habitat use of loggerhead turtles in the northern Gulf of Mexico	1). Satellite and acoustic telemetry data for adult and juvenile loggerheads will be analyzed to identify their movement corridors and foraging locations, 2). Genetic analyses will be conducted to determine genetic origins of juvenile loggerheads using NW Florida coastal habitat, 3). Ocean models will be used to define hatchling dispersal from nesting beaches in the northern Gulf of Mexico, and 4). Surface drifters will be deployed in the northern Gulf to further refine and validate ocean models.
Sheet 1

 

[hiker95]

crobert8,

Can we have two screenshots of the New Sheet:

1. the way it looks when you first receive it

2. the way it should look (manually formatted by you) for the results you are looking for, with all fields filled in.