Columns merging and cropping

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP


Columns merging and cropping



I am not an Excel expert and have a little problem:



I have a very basic table with only 3 columns: keywords, names, and production stages. I need some kind of action that simply combines the first two columns. The file I have crops the kids' names (second column).



For example,



ORIGINAL FIELDS



nicer michael print /
kinder amalia design /
kinder ava print /
nicer charlotte design /
nicer liam print



SHOULD BECOME



nicermichael print /
kinderamalia design /
kinderava print /
nicercharlotte design /
nicerliam print



BUT BECOMES



nicermich print /
kinderama design /
kinderava print /
nicerchar design /
nicerliam print



Does anyone have any idea why it works this way?
Thank you!!




1 Answer
1



There are two ways to do this:



A more detailed explanation is given in: https://www.ablebits.com/office-addins-blog/2013/10/13/merge-columns-excel-without-losing-data/






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

Makefile test if variable is not empty

Will Oldham

Visual Studio Code: How to configure includePath for better IntelliSense results