I.T Solution | I.T Training | I.T Integration System

Excel change columns to rows, or rows to columns

Excel change columns to rows, or rows to columns
(Mengubah posisi column menjadi row data atau sebaliknya)

While working in Excel you realize that you wish the data was oriented differently in your spreadsheet.

Select data, copy, select empty area, paste special, check transpose box.


Once you realize that your data is not in the best orientation you might be tempted to start over or to copy your data cell by cell to the right orientation. Hold everything, there is a better way. Using the Transpose feature in Excel you can switch around your column and row data with a few clicks of the mouse. In the example only one row of data is being transposed to a column but you can also select an entire block of data and transpose will switch all the selected rows and columns at once.

-Select a row, column, or block of data to transpose.
-Right click the selected cells and select paste special from the menu
-Right click an empty section of the spreadsheet and select Paste Special from the popup menu
-On the Paste Special menu check the box for Transpose-Click OK

SISINDOTEK – I.T Training & Solution Provider
Jl. Sukasenang VI – 6 B Cikutra Bandung
Jawa Barat 40124
Tel. 022-71242266, 0812.8733.1966
Email : info , YM. sisindotek , ,


Single Post Navigation

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: