Excel row to column sorting

[HETALK01]

Hello,

I have data in the below format in excel with Name and Marks as Row Names :

Name Hetal
Marks 60
Name Jimy
Marks 40
Name Lilly
Marks 70

I want above data as below :

Name Marks
Hetal 60
Jimy 40
Lilly 70

Appreciate your help!

Thanks,
Hetal

 

[jarjarbingie]

Hello,

I have data in the below format in excel with Name and Marks as Row Names :

Name Hetal
Marks 60
Name Jimy
Marks 40
Name Lilly
Marks 70

I want above data as below :

Name Marks
Hetal 60
Jimy 40
Lilly 70

Appreciate your help!

Thanks,
Hetal

assuming table 1 is in cells A2:B7, add a helper column using this formula:

C2=COUNTIF($A$2:A2,A2)

then in a separate sheet:

A2=OFFSET(Sheet1!$B$1,MATCH(ROW()-1,Sheet1!$C$2:$C$7,0),0)
B2=OFFSET(Sheet1!$B$1,MATCH(ROW()-1,Sheet1!$C$2:$C$7,0)+1,0)

 

[HETALK01]

Hello,

Thanks for your response. It works.
But Instead of Marks column, if i have date column, having values like

Name Hetal
Date 29-10-2007
Name Puja
Date 09-08-2017

For the date values, it show some random numbers.

Can you help here please.

Thanks,
Hetal

 

[jarjarbingie]

Hello,

Thanks for your response. It works.
But Instead of Marks column, if i have date column, having values like

Name Hetal
Date 29-10-2007
Name Puja
Date 09-08-2017

For the date values, it show some random numbers.

Can you help here please.

Thanks,
Hetal

just format that column as Date