Home News Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | Excel question : help please

You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > Computers & IT > General IT Discussion

Excel question : help please
Reply
 
Thread Tools
Old 29-08-2018, 08:16   #1
Mike
cf.mega poster
 
Mike's Avatar
 
Join Date: Jan 2004
Age: 56
Posts: 2,235
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, 9 views)
Mike is offline   Reply With Quote
Advertisement
Old 29-08-2018, 12:17   #2
spanna
Old Fart
 
Join Date: Jul 2007
Posts: 95
spanna has a spectacular aura about themspanna has a spectacular aura about themspanna has a spectacular aura about themspanna has a spectacular aura about them
Re: Excel question : help please

I'm no expert but does this help?
Attached Files
File Type: xls Pivot test.xls (34.5 KB, 9 views)
spanna is offline   Reply With Quote
Old 29-08-2018, 14:39   #3
Mike
cf.mega poster
 
Mike's Avatar
 
Join Date: Jan 2004
Age: 56
Posts: 2,235
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
Re: Excel question : help please

Quote:
Originally Posted by spanna View Post
I'm no expert but does this help?

Yes it does thanks....got it...

It was just my spreadsheet displayed different options

Thanks again

Mike

Last edited by Mike; 29-08-2018 at 14:51.
Mike is offline   Reply With Quote
Old 29-08-2018, 14:46   #4
Lutherf
cf.member
 
Join Date: Aug 2018
Posts: 51
Lutherf will become famous soon enoughLutherf will become famous soon enoughLutherf will become famous soon enough
Re: Excel question : help please

You are looking for a function that Access is MUCH better suited for.
Lutherf is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:32.


Server: xenon.zmnt.net
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2018, vBulletin Solutions Inc.