How to Convert a Column to a Row in Excel

Sometimes we’ve entered data in a column in Excel, only to realize later that it would be better to have this data in a row, or vise-versa.  Here’s a simple trick to convert any row or set of rows into a column, or vise-versa, in Excel.In case of Bulk data you want to convert in rows from column you don’t need to reenter data in rows and don’t need to waste your time.

Please Note: This is tested in Excel 2003, 2007, and 2010.  Here we took screenshots from Excel 2010 x64, but it works the same on the other versions.

Convert a Row to a Column

Here’s Sample data in Excel:

How to convert column in rows

If you want to change these two data columns into rows.  Select all the cells you wish to convert, right-click, and select copy (or simply press Ctrl+C):

Microsoft excel

Now, you should do right-click in the cell where you want to put the data in rows, and select “Paste Special Option from that drop down manue.”

Convert column in rows

Now a Pop up Window will be open.Check the box at the bottom that says “Transpose”, and then click OK.

Microsoft excel 2007

Now your Sample data will be converted in rows from columns! 

Microsoft excel 2003

This works the exact same for converting rows into columns.  Here’s some data in rows:


After copying and pasting special with Transpose selected, here’s the data in columns! This way you can save your time.

Microsoft excel

This is a great way to get your data organized just like you want in Excel.

How to Install Memcached on Linux Server?

Memcached is a caching mechainsm for PHP which helps server to speed up serving data from data stores in RAM. Memcache runs as a server utilite which compiles data once and serve it, Memcached is very furuit full to reduce the resource utilization of the server.

Download PECL Memcache Demon:

[sourcecode language="plain"]</span>
<span style="color: #000000;">pecl install memcache</span>
<span style="color: #000000;">cd /usr/local/src/</span>
<span style="color: #000000;">pecl download memcache</span>
<span style="color: #000000;">[/sourcecode]

Unpack the tar and newly created directory:

[sourcecode language="plain"]</span>
<span style="color: #000000;">tar -xvzf memcache-X.X.X.tgz</span>
<span style="color: #000000;">cd memcache-X.X.X</span>
<span style="color: #000000;">[/sourcecode]

Configure and Install:

[sourcecode language="plain"]</span>
<span style="color: #000000;">/usr/local/bin/phpize</span>
<span style="color: #000000;">./configure –with-php-config=/usr/local/bin/php-config</span>
<span style="color: #000000;">[/sourcecode]

Verify Memcached Install :

[sourcecode language="plain"]</span>
<span style="color: #000000;">php -m</span>
<span style="color: #000000;">memcache</span>
<span style="color: #000000;">[/sourcecode]

Don’t forget to Secure Memcached listing port.

[sourcecode language="plain"]</span>
<span style="color: #000000;">vi /etc/sysconfig/memcached</span>
<span style="color: #000000;">file, changing the line</span>
<span style="color: #000000;">OPTIONS=""</span>
<span style="color: #000000;">to</span>
<span style="color: #000000;">OPTIONS="-l"</span>
<span style="color: #000000;">[/sourcecode]

This will ensure that Memcached only respond to local host.

How to Create a Multireddit in Reddit! Image Guide

The ability to create multireddits is a relatively new feature added to Reddit that allows users to lump reddits together based on their own preferences. You can choose setting of your own will like Public or private. This way You can improve your content Syndication’s on Reddit.

1) Click on the sidebar to show the multireddit menu.

How to create Sub reddits

2) Press the “create” button.

How to create Sub reddits

3) Type in a name for the new multireddit. Remember that names cannot have spaces!

create Sub reddits

4) Type in all of the subreddits that you want to merge into the multireddit.

Sub reddits

5) Add a short description if needed.

How to create Sub reddits

How To Install Windows 7 Through Images Guide

Many Home based users of computers don’t know about window installation method properly. For All Computers users help Techsecret here provided complete solution through images step by step. 

Window 7 installation

Select your language, time & currency format, keyboard or input method and click Next.

install window guide
Continue reading How To Install Windows 7 Through Images Guide