How to Use Transpose in Excel

How to Use Transpose in Excel 

Transpose used to Convert Row Values to Column Values. 

Ex: 

product	jan	feb	mar
TV	500	400	150
LED	600	200	200
LCD	1500	100	300

In the above table we can change row labels as column labels by following below steps. 

steps :

1. Select whole data from the table 

2. Right click -> Copy.

3. Now , go to next sheet 

4. Right click -> Paste special -> Transpose. 

product	TV	LED	LCD
jan	500	600	1500
feb	400	200	100
mar	150	200	300

How to Create a Day Series in Excel Column

Create a Day Series in Excel Column

Hi..

      Readers ! Let us learn how to Create a day series in 'Date' in Excel sheet, Here We make continuously changing 'Day' in the 'date' format in a column series while drag mouse pointer. Even we can make to changing 'Month' or 'Year' continuously by using this tip.   follow the below steps to make this easy.

Step 1:

in the above picture

1. first enter a date '01-20-2001' in column 'A' in cell 'A1'

2. select entire column 'A'

3. Home tab -> fill -> Click 'series' 

4. now pop-up will come like above screen

5. enable series in 'Column'

6. enable Type 'Date'

7. enable Date unit 'Day'

8. Click to 'Ok' 

Now you will changing day in date series in column 'A' , Now you can try for Month, Weekday or Year same like this. 

Thank you

Excel tric blog