• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

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 excel screenshot
0
esvfan1
Asked:
esvfan1
1 Solution
 
NorieVBA ExpertCommented:
Select column D and copy it, then Paste>Paste Special... Values back to column D.

Now you can delete the other columns.
0
 
esvfan1Author Commented:
Thanks.. Worked Great!
0
 
Steven CarnahanNetwork ManagerCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now