davidplowman
New Member
- Joined
- Oct 31, 2013
- Messages
- 10
Hello:
I have an issue and I'm hoping someone can help me with.
I have a spreadsheet that's has 28 columns and more than 3,000 rows.
One of the columns is a year range (i.e. 2010-2013, 1988-1999, 1996-1998 or whatever).
The file has to be submitted to another department for an upload to a website, and each year has to be listed on a separate row, with all of the information remaining the same.
So in other words, a portion of my spreadsheet that looks like this:</SPAN>
<TBODY>
</TBODY>
Would ultimately look like this:</SPAN>
<TBODY>
</TBODY>
The problem is I’m not sure of the best way to get from Point A to Point B. I would image in would involve splitting the beginning and end year into end rows, then calculating the year range (3 years, 1 year and 4 years.)</SPAN>
But I’m unsure of what to do from there? Is it just a process of manually inserting the rows and copying in the information from the other columns, or is there a quicker, more efficient way of doing this?</SPAN>
As a side note, I’m familiar with many of the “advanced” functions of Excel, but haven’t done any VBA program yet. But if there is a program that would help, I’m willing to take the plunge into learning about it.</SPAN>
Thanks,</SPAN>
David</SPAN>
I have an issue and I'm hoping someone can help me with.
I have a spreadsheet that's has 28 columns and more than 3,000 rows.
One of the columns is a year range (i.e. 2010-2013, 1988-1999, 1996-1998 or whatever).
The file has to be submitted to another department for an upload to a website, and each year has to be listed on a separate row, with all of the information remaining the same.
So in other words, a portion of my spreadsheet that looks like this:</SPAN>
Source</SPAN></SPAN> | New PN (Main # to Search By)</SPAN></SPAN> | Make</SPAN></SPAN> | Vehicle Type</SPAN></SPAN> | Year (From - To)</SPAN></SPAN> | Model</SPAN></SPAN> | Engine</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 2010-2013</SPAN></SPAN> | DB</SPAN></SPAN> | FE</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 2012-2013</SPAN></SPAN> | DB</SPAN></SPAN> | HA</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 1999-2003</SPAN></SPAN> | Various Models</SPAN></SPAN> | FE</SPAN></SPAN> |
<TBODY>
</TBODY>
Would ultimately look like this:</SPAN>
Source</SPAN></SPAN> | New PN (Main # to Search By)</SPAN></SPAN> | Make</SPAN></SPAN> | Vehicle Type</SPAN></SPAN> | Year (From - To)</SPAN></SPAN> | Model</SPAN></SPAN> | Engine</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 2010</SPAN></SPAN> | DB</SPAN></SPAN> | FE</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 2011</SPAN></SPAN> | DB</SPAN></SPAN> | FE</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 2013</SPAN></SPAN> | DB</SPAN></SPAN> | FE</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 2012</SPAN></SPAN> | DB</SPAN></SPAN> | HA</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 2013</SPAN></SPAN> | DB</SPAN></SPAN> | HA</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 1999</SPAN></SPAN> | Various Models</SPAN></SPAN> | FE</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 2000</SPAN></SPAN> | Various Models</SPAN></SPAN> | FE</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 2001</SPAN></SPAN> | Various Models</SPAN></SPAN> | FE</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 2002</SPAN></SPAN> | Various Models</SPAN></SPAN> | FE</SPAN></SPAN> |
Lester</SPAN></SPAN> | A7T03277A</SPAN></SPAN> | Hyster</SPAN></SPAN> | Lift Truck</SPAN></SPAN> | 2003</SPAN></SPAN> | Various Models</SPAN></SPAN> | FE</SPAN></SPAN> |
<TBODY>
</TBODY>
The problem is I’m not sure of the best way to get from Point A to Point B. I would image in would involve splitting the beginning and end year into end rows, then calculating the year range (3 years, 1 year and 4 years.)</SPAN>
But I’m unsure of what to do from there? Is it just a process of manually inserting the rows and copying in the information from the other columns, or is there a quicker, more efficient way of doing this?</SPAN>
As a side note, I’m familiar with many of the “advanced” functions of Excel, but haven’t done any VBA program yet. But if there is a program that would help, I’m willing to take the plunge into learning about it.</SPAN>
Thanks,</SPAN>
David</SPAN>