Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kam Kam is offline
external usenet poster
 
Posts: 57
Default Lock lines together to creat pivot table?

I have a data sheet that I would like to creat a pivot table off of. My
problem is line 2, 3, 4, and 5 I would like to keep together and 6, 7, 8 and
9 should display togther, and so on.... I am not a pivot table queen so just
wonder if there's someone out there that know's how to do this or if it can
be done..
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,276
Default Lock lines together to creat pivot table?

Hi Kam,
I assume you have a reason for grouping in that way, maybe a cost center or
department so what you can do is add a column to your information let's say
"Departments" and then assign a department to each line. When doing the Pivot
table you select the departments then you are able to expand the department
you want or have just the summary

"KAM" wrote:

I have a data sheet that I would like to creat a pivot table off of. My
problem is line 2, 3, 4, and 5 I would like to keep together and 6, 7, 8 and
9 should display togther, and so on.... I am not a pivot table queen so just
wonder if there's someone out there that know's how to do this or if it can
be done..

  #3   Report Post  
Posted to microsoft.public.excel.programming
Kam Kam is offline
external usenet poster
 
Posts: 57
Default Lock lines together to creat pivot table?

I am working with a spread sheet that someone else made, it's over 90,000
lines and for some reason they didn't use the columns going across (probable
for printing purpose) instead they used 5 lines (going down) to inter their
information. So say line 1 column "a" is serical numbers for an irrigation
engine, column "b" is customer name then on line 2 column "a" is permit
number and column "b" is street address. So one engine is taking up 5 lines,
those 5 lines I want to "stick" together when doing a pivot table. Is this
impossible to work with?

"Eduardo" wrote:

Hi Kam,
I assume you have a reason for grouping in that way, maybe a cost center or
department so what you can do is add a column to your information let's say
"Departments" and then assign a department to each line. When doing the Pivot
table you select the departments then you are able to expand the department
you want or have just the summary

"KAM" wrote:

I have a data sheet that I would like to creat a pivot table off of. My
problem is line 2, 3, 4, and 5 I would like to keep together and 6, 7, 8 and
9 should display togther, and so on.... I am not a pivot table queen so just
wonder if there's someone out there that know's how to do this or if it can
be done..

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,276
Default Lock lines together to creat pivot table?

Hi Kam,
How you describe yes is imposible to work with, the only solution will be to
put that 5 lines in one in different columns and the concatenate all the
columns. to do that highlight the 5 lines, copy, then in the same place do
paste special, transpose, that will put all the text in 5 different columns,
then use concatenate to join all the columns. Hope this help

"KAM" wrote:

I am working with a spread sheet that someone else made, it's over 90,000
lines and for some reason they didn't use the columns going across (probable
for printing purpose) instead they used 5 lines (going down) to inter their
information. So say line 1 column "a" is serical numbers for an irrigation
engine, column "b" is customer name then on line 2 column "a" is permit
number and column "b" is street address. So one engine is taking up 5 lines,
those 5 lines I want to "stick" together when doing a pivot table. Is this
impossible to work with?

"Eduardo" wrote:

Hi Kam,
I assume you have a reason for grouping in that way, maybe a cost center or
department so what you can do is add a column to your information let's say
"Departments" and then assign a department to each line. When doing the Pivot
table you select the departments then you are able to expand the department
you want or have just the summary

"KAM" wrote:

I have a data sheet that I would like to creat a pivot table off of. My
problem is line 2, 3, 4, and 5 I would like to keep together and 6, 7, 8 and
9 should display togther, and so on.... I am not a pivot table queen so just
wonder if there's someone out there that know's how to do this or if it can
be done..

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table 2003 - Creat a column using absolute cells o/s the tab Ed Bonk Excel Worksheet Functions 1 October 13th 07 01:03 AM
Filter lines with Pivot table and non pivot table columns Grover Charts and Charting in Excel 4 September 28th 07 03:16 AM
Filter lines with Pivot table and non Pivot table columns Grover Excel Discussion (Misc queries) 1 September 26th 07 12:48 AM
Filter lines containing pivot table and non pivot table data Grover Excel Worksheet Functions 0 September 24th 07 07:20 PM
Pivot Table Q: Creat using fieldA valueB OR fieldC valueD? Jan K Excel Discussion (Misc queries) 2 February 20th 06 03:34 PM


All times are GMT +1. The time now is 03:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"