helloras123
New Member
- Joined
- Apr 13, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi,
I am a new excel user and need to do some cleaning on the data. I have a file that has columns A to G. If any row has values in column F/G (or both) then create a new row where column A and Column B should be replaced with Column F and Column G values respectively and all of the other records from column C to Column G should remain the same. Parent record should also remain the same without any edit. Is there a way I can achieve the end result?
I am a new excel user and need to do some cleaning on the data. I have a file that has columns A to G. If any row has values in column F/G (or both) then create a new row where column A and Column B should be replaced with Column F and Column G values respectively and all of the other records from column C to Column G should remain the same. Parent record should also remain the same without any edit. Is there a way I can achieve the end result?