Nick Burns
Member
- Joined
- May 24, 2017
- Messages
- 162
- Reaction score
- 0
- Points
- 16
- Excel Version(s)
- Office 365
Seems all my questions tend to be working with multiple columns.
I have 52 columns laid out in this fashion.
If Column1 is null, I need to copy all the 26 X.columns over to the 26 main columns. (Yes the columns are named the same, the X.Columns have a prefix)
So this ....
Becomes this ...
I'm trying to avoid using pivots as there can be millions of rows, and my computer seems to choke when pivoting the much data.
Trying to come up with a TransformFields or TransformColumns routine, but having a tough time getting a list of values from the X.Columns.
I have 52 columns laid out in this fashion.
If Column1 is null, I need to copy all the 26 X.columns over to the 26 main columns. (Yes the columns are named the same, the X.Columns have a prefix)
So this ....
Column1 | Column2 | Column3 | Column4... | X.Column1 | X.Column2 | X.Column3 | X.Column4... |
Data1 | Data1 | Data1 | Data1 | ||||
Data2 | Data2 | Data2 | Data2 | ||||
xData3 | xData3 | xData3 | xData3 | ||||
Data4 | Data4 | Data4 | Data4 | ||||
xData5 | xData5 | xData5 | xData5 | ||||
xData6 | xData6 | xData6 | xData6 |
Becomes this ...
Column1 | Column2 | Column3 | Column4... |
Data1 | Data1 | Data1 | Data1 |
Data2 | Data2 | Data2 | Data2 |
xData3 | xData3 | xData3 | xData3 |
Data4 | Data4 | Data4 | Data4 |
xData5 | xData5 | xData5 | xData5 |
xData6 | xData6 | xData6 | xData6 |
I'm trying to avoid using pivots as there can be millions of rows, and my computer seems to choke when pivoting the much data.
Trying to come up with a TransformFields or TransformColumns routine, but having a tough time getting a list of values from the X.Columns.