Conditionally Replace Multiple Columns

Nick Burns

Member
Joined
May 24, 2017
Messages
162
Reaction score
0
Points
16
Excel Version(s)
Office 365
TESTSATSUNMONTUEWEDTHUFRI
DEL0000000
R0088888



Using the table above, I'd like to null out the values of SAT-FRI when the value in TEST = DEL.
Not sure if this would be a Table.ReplaceValue, but thinking this is a TransformColumns issue.
 
Why not keep it simple? Unpivot those columns, add a column with null for that condition, delete the original Value and rename the new column, then pivot back.
 
I get what your saying, but call it my anxiety, but if my recordset has 2,000+ rows, doesn't pivoting the columns now make the dataset 14,000+ rows to now check causing a lot of processing time?
Or is the processing still the same since I'm doing the replacement 7 times over the course of 2,000 records?
 
Back
Top