JoeGKushner
New member
- Local time
- Yesterday, 18:04
- Joined
- Jun 23, 2015
- Messages
- 9
I'm trying to clean up a file from a legacy system that is no longer supported.
I can remove all the unwanted data by testing the first cell. If it's X, Y, or Z, delete it.
Then there are lines that are children of parents. I want to put the parent in front of the child. I'm marking a 'helper' column to determine if it's a child or parent. The problem is that if it's a parent for multiple lines.
So for example, I've attached a file.
Column A is the Buyer Code. Using it to test a condition.
Column B testing that condition.
Column C Trying to put the parent in place.
Column D is either the parent or the child.
Column E is the raw data.
So Column C is the problem. When there is a need for the parent to cover multiple lines, I can't figure it out.
Line 36, 37, and 38 for example, should all be the same, based on the information on D35. but when moving onto the next field, it follows Excel's pattern and makes the information D36, etc...
I need a way to make the Lines all the same if the criteria is meet. In this instance, it's if A and B are the same, the data should be from the first line that they were the same all the way until A and B change.
Does that make sense?
I can remove all the unwanted data by testing the first cell. If it's X, Y, or Z, delete it.
Then there are lines that are children of parents. I want to put the parent in front of the child. I'm marking a 'helper' column to determine if it's a child or parent. The problem is that if it's a parent for multiple lines.
So for example, I've attached a file.
Column A is the Buyer Code. Using it to test a condition.
Column B testing that condition.
Column C Trying to put the parent in place.
Column D is either the parent or the child.
Column E is the raw data.
So Column C is the problem. When there is a need for the parent to cover multiple lines, I can't figure it out.
Line 36, 37, and 38 for example, should all be the same, based on the information on D35. but when moving onto the next field, it follows Excel's pattern and makes the information D36, etc...
I need a way to make the Lines all the same if the criteria is meet. In this instance, it's if A and B are the same, the data should be from the first line that they were the same all the way until A and B change.
Does that make sense?
