How To Use Fill Justify Function Transfer Rows to a Column In Excel

In Excel, Fill Justify function is an interesting feature that allows users to reformat text so that it fits into a pre-selected space. But do you know Fill Justify Function can transfer rows to a column Ok, let's look this excellent feature.

For example, how to transfer A1:C4 to column E, see figure below:

Getting the data

Copy A1:C4 to a new worksheet to start this tutorial.

Use Fill Justify Function Transfer Rows to a Column

1. Select A1:C4.
2. Press CTRL+C.
3. Under the Home menu tab, in the Clipboard group, click the Clipboard button to show the office Clipboard Task Pane.
   
4. Double click E1. Or select E1, then press F2.
5. Click the item that we copied in the clipboard.
   
6. Press CTRL+H to open Find and Replace window.
7. In Find what box, hold down the ALT key, type 10 on the number pad, then releasing ALT. This step will enter line break symbol (ALT+10).
   
8. In Replace with box, input a space. Then click Replace All.
   
9. Click Ok to close the dialogue box.
10. Click Close to close Find and Replace.
11. Change the width of Column E. Drag the boundary on the right side of the Column E heading until the column is only display one character.
12. Under the Home menu tab, in the Editing group, click the Fill button, then choose Justify.
    
13. Click OK to close the warning dialogue box.
14. Under the Data menu tab, in the Tata Tools group, click the Text to Columns button, then click Finish in the Convert Text to Columns Wizard window.

Video Tutorial