Greetings,<o
></o
>
<o
> </o
>
I'm exporting data from a Rational database application into an Excel 2010 spreadsheet. I need to parse the data in a way that will group the data by object ID (XX-YY-25xx). <o
></o
>
<o
> </o
>
https://www.box.com/s/vgq2hk2bq24ik7jjck9w<o
></o
>
<o
> </o
>
In the Sample Worksheet.xlsx file, on the Source sheet, I have a single Source column with multiple entries in each cell that are separately by what appears to be the ALT+ENTER character.<o
></o
>
<o
> </o
>
XX-YY-2516<o
></o
>
Nunc tincidunt commodo iaculis:<o
></o
>
Nam faucibus in nulla eu consectetur.<o
></o
>
Cras aliquet fringilla augue, eget venenatis sapien euismod quis.<o
></o
>
Sed sagittis pulvinar lorem vitae euismod.<o
></o
>
XX-YY-2517<o
></o
>
Etiam eu commodo diam.<o
></o
>
<o
> </o
>
My goal is to parse out each of these entries as shown in the Output sheet, grouping them by object ID (XX-YY-25xx). I’m looking for a macro that will parse the data in the Source sheet so that it looks like the data in the Output sheet. Here are some additional notes:<o
></o
>
<o
> </o
>
1) I would like to have the macro ignore the first header row of the Source sheet, then perform its actions on how ever many rows are in the sheet, stopping when it reaches the end of populated rows (the actual output may range from a few dozen rows to hundreds of rows).<o
></o
>
2) The output can overwrite the data in the Source sheet, or be written to a new sheet in the workbook.<o
></o
>
3) Each grouped set of output data (Output sheet, ID column) will always begin with the “XX-YY-“ characters. When parsing through the source data (Source sheet, Source column) the macro should identify the first “XX-YY-“ entry, and then parse the data directly below until the next “XX-YY-“ entry is found, or the end of the cell is reached. <o
></o
>
<o
> </o
>
Can someone please provide me with a simple macro to do this?<o
></o
>
<o
> </o
>
Thanks in advance.<o
></o
>
<o
> </o
>
Paul<o
></o
>
<o
I'm exporting data from a Rational database application into an Excel 2010 spreadsheet. I need to parse the data in a way that will group the data by object ID (XX-YY-25xx). <o
<o
https://www.box.com/s/vgq2hk2bq24ik7jjck9w<o
<o
In the Sample Worksheet.xlsx file, on the Source sheet, I have a single Source column with multiple entries in each cell that are separately by what appears to be the ALT+ENTER character.<o
<o
XX-YY-2516<o
Nunc tincidunt commodo iaculis:<o
Nam faucibus in nulla eu consectetur.<o
Cras aliquet fringilla augue, eget venenatis sapien euismod quis.<o
Sed sagittis pulvinar lorem vitae euismod.<o
XX-YY-2517<o
Etiam eu commodo diam.<o
<o
My goal is to parse out each of these entries as shown in the Output sheet, grouping them by object ID (XX-YY-25xx). I’m looking for a macro that will parse the data in the Source sheet so that it looks like the data in the Output sheet. Here are some additional notes:<o
<o
1) I would like to have the macro ignore the first header row of the Source sheet, then perform its actions on how ever many rows are in the sheet, stopping when it reaches the end of populated rows (the actual output may range from a few dozen rows to hundreds of rows).<o
2) The output can overwrite the data in the Source sheet, or be written to a new sheet in the workbook.<o
3) Each grouped set of output data (Output sheet, ID column) will always begin with the “XX-YY-“ characters. When parsing through the source data (Source sheet, Source column) the macro should identify the first “XX-YY-“ entry, and then parse the data directly below until the next “XX-YY-“ entry is found, or the end of the cell is reached. <o
<o
Can someone please provide me with a simple macro to do this?<o
<o
Thanks in advance.<o
<o
Paul<o