Thread: Excel question : help please
View Single Post
Old 29-08-2018, 08:16   #1
Mike
cf.mega poster
 
Join Date: Jan 2004
Age: 61
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Excel question : help please
Hi all

Would appreciate any help with this please, I would like to try and get data (text) on the same line rather than as a sub group under a heading

Ie List

City Street Cost
London High Street 100
London Long Road 200
London High Street 50

To show...

London High Street 150
London Long Road 200
Total 350

Also attach the spreadsheet which show what I currently have and what I would like.

Many thanks for your help and time

Regards

Mike
Attached Files
File Type: xls Pivot test.xls (32.0 KB, 10 views)
Mike is offline   Reply With Quote