Pivot trouble

rugbytomc

New Member
Joined
Jul 25, 2013
Messages
13
wasn't sure what to title this.

If i have data as such

NameScore
Ian1
Ian2
Ian3
Ian4
James1
James2
James3
James4
John1

<tbody>
</tbody>

What I want to see is this
NameScore 1Score 2Score 3Score 4Score 5
Ian1234
James12345
John1

<tbody>
</tbody>


Any suggestions on how best to do that?

Thanks
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

slpswhite

New Member
Joined
Jan 2, 2018
Messages
39
Create a Pivot table and use the names as Row Labels and use Score as both Column Labels and Values. It should give you what you want.

Row Labels1234Grand Total
Ian123410
James123410
John11
Grand Total346821

<tbody>
</tbody><colgroup><col><col><col span="3"><col></colgroup>
 

Watch MrExcel Video

Forum statistics

Threads
1,127,581
Messages
5,625,611
Members
416,124
Latest member
DeMoNloK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top