Forum Discussion
Need help replacing value x with column headers
Scenario - I have product names in Col1 followed by Product group Headers(H1...H4) . The value X indicates that Product A belongs to Product Group H1. I would like to repace X's with respective prod...
You will need to transpose your table, then Replace Value under the Transform Tab, then once completed transpose your table back.