Combining two data columns using Excel shortcuts

 In Uncategorized

Excel shortcuts

Excel shortcuts

Play Game Now
Excel shortcuts

We have two columns in Excel with mutually disjoint data in cells. It is necessary to combine the data from two columns into one (for example, for further calculations, etc.). We will use Excel shortcuts.

Excel columns

You can start thinking about formulas or even macros. But there is a much easier and more elegant way to do that.

Select all cells in the column C, rows 2-15, and Copy (Ctrl + C).

 

There is an elegant method for solving this problem using Excel hot keys

 

Select all cells in the column B, rows 2-15, and use Paste Special command (Ctrl + Alt + V for the Excel shortcut). In the opened special parameters window, enable the “Skip Blanks” check box (Alt + B for the hot key) and click “Enter” for OK :

Excel shortcuts Advanced Excel

The data copied from the column C is inserted into the column B. In this case, empty cells from the second column will be skipped during the insertion and will not erase the values ​​from the first column.

 

Simple and effective, using Excel shortcuts makes it even quicker!

 

 

Even more Excel tips and tricks here:

 

Play Game Now

Recent Posts

Leave a Comment

How can we
help you?
Contact Us

Please, leave a message and we'll get back to you asap

Try Excel Game

for FREE

  • Become 10 times quicker in Excel with new tricks
  • Learn new Excel tricks 5 times faster with Excel Game
  • Try 3 Hot Key Excellence topics for free