Column,Columns,Row,Rows,Transpose Function in Excel

 

Column Function

 

=COLUMN(B2)

 

	A	B	C
1	Name	Marks	Position
2	Raman	48	2
3	Raj	75	2
4	Karan	85	2
5	4567	96	2
6	Deepak	55	2
7	5263	96	2
8	Radha	74	2

 

Columns Function

 

=COLUMNS(B1)

 

	A	B	C
1	Name	Marks	Position
2	Raman	85	2
3	Raj	84	2
4	Karan	96	2
5	Rahul	62	2
6	Deepak	74	2
7	Geeta	52	2
8	Radha	84	2

 

Row Function

 

=ROW(A2)

 

	A	B	C
1	Name	Marks	Position
2	Raman	48	2
3	Raj	75	3
4	Karan	85	4
5	Rahuk	96	5
6	Deepak	55	6
7	Kishan	96	7
8	Radha	74	8

 

Rows Function

 

=ROWS(A2:B8)

 

	A	B	C
1	Name	Marks	Position
2	Raman	48	6
3	Raj	75	7
4	Karan	85	7
5	Rahuk	96	7
6	Deepak	55	7
7	Kishan	96	7
8	Radha	74	7

 

Transpose Function

 

=TRANSPOSE(B2:B8)

Press Ctrl+Shift+Enter

	A	B
1	Name	Marks
2	Raman	48
3	Raj	75
4	Karan	85
5	Rahuk	89
6	Deepak	55
7	Kishan	96
8	Radha	74

 

Name	Raman	Raj	Karan	Rahuk	Deepak	Kishan	Radha
MARKS	48	75	85	89	55	96	74