I am trying to output concatenated content into defined columns. There are 6 pre-defined columns (see the image below): Requirement Text, Requirement Rationale, Requirement Guidance, Requirement Lessons Learned, Verification Rationale, Verification Guidance, and Verification Lessons Learned.
I have the date imported to Excel in the following format:
Here you can see that every column header I provided above has a separate row with that title preceding the text. Many times there are multiple rows within these headers that need to be concatenated and then output. I am looking for help on a VBA code or Excel formula that will do the following:
1. Parse the column (Column A).
2. Every time it sees X.* (where X is any letter), it concatenates and outputs the rows below it to a Requirement Text column and only stops once it reaches a Requirement Rationale row.
3. Once it reaches Requirements Rationale row, it does the same thing (concatenates and outputs to a Requirement Rationale column) until it reaches a Requirements Guidance row.
4. Same for Requirements Guidance until we reach a Verification Rationale row.
5. Same for Verification Rationale until we reach a Verification Guidance row.
6. Same for Verification Guidance until we reach a Verification Lessons Learned row.
7. Same for Verifications Lessons Learned until we reach a X.* row OR until we reach a blank (this would represent the end of the data).
To provide another graphic, I'd like to transform the following data of column to the disparate columns while possibly maintaining the requirement name (X.*) the data is associated with though that is not necessary and can be done afterwards. Any help here would be greatly appreciated!
I have the date imported to Excel in the following format:
Here you can see that every column header I provided above has a separate row with that title preceding the text. Many times there are multiple rows within these headers that need to be concatenated and then output. I am looking for help on a VBA code or Excel formula that will do the following:
1. Parse the column (Column A).
2. Every time it sees X.* (where X is any letter), it concatenates and outputs the rows below it to a Requirement Text column and only stops once it reaches a Requirement Rationale row.
3. Once it reaches Requirements Rationale row, it does the same thing (concatenates and outputs to a Requirement Rationale column) until it reaches a Requirements Guidance row.
4. Same for Requirements Guidance until we reach a Verification Rationale row.
5. Same for Verification Rationale until we reach a Verification Guidance row.
6. Same for Verification Guidance until we reach a Verification Lessons Learned row.
7. Same for Verifications Lessons Learned until we reach a X.* row OR until we reach a blank (this would represent the end of the data).
To provide another graphic, I'd like to transform the following data of column to the disparate columns while possibly maintaining the requirement name (X.*) the data is associated with though that is not necessary and can be done afterwards. Any help here would be greatly appreciated!
