Link to home
Start Free TrialLog in
Avatar of esvfan1
esvfan1Flag for United States of America

asked on

Excel: Merge columns then delete original data

I need to take columns E,F,G .. merge them into D.. (easy enough) but how to i make D's result static so i can delete E,F,G's data User generated image
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of esvfan1

ASKER

Thanks.. Worked Great!
You could play with a macro to accomplish it.  This one isn't complete and set for the columns you asked about but it will give you a starting point should you decide to go down that path.  :)

 test.xlsm