starting a pivot table

[Cindy]

I've never done a pivot table before, so i don't really know what i'm doing. I'm trying to create one but the data i have isnt single rows. Instead it is chunks of rows and columns. For example, i have five columns and the first column has one thing under it, the next has one, but the next has three things and the next has one and the last has five things. But those are all one group of data because they all belong to whats listed in the first column. Can anyone understand what i mean?

 

[Andy B]

Hi

It sounds like the data contained in the other columns are not 'linked' to
the first column. If this is the case, what you need to do (I reckon) is to
complete column 1, so that there are no blanks. This should then make it
easy to pivot.
One way of doing this is to select the column / range. Then Edit / Go to /
Special / Blanks. This will
select all of the blank cells in the range. Type = and hit the up arrow and
then type Ctrl Enter. To fix these values use Copy then Paste Special /
Values.
Let me know if I'm a mile off-course!

--
Andy.

I've never done a pivot table before, so i don't really know what i'm

doing. I'm trying to create one but the data i have isnt single rows.
Instead it is chunks of rows and columns. For example, i have five columns
and the first column has one thing under it, the next has one, but the next
has three things and the next has one and the last has five things. But
those are all one group of data because they all belong to whats listed in
the first column. Can anyone understand what i mean?

 

[Cindy]

Thanks a lot, i'll try it and see how it works

Hi

It sounds like the data contained in the other columns are not 'linked' to
the first column. If this is the case, what you need to do (I reckon) is to
complete column 1, so that there are no blanks. This should then make it
easy to pivot.
One way of doing this is to select the column / range. Then Edit / Go to /
Special / Blanks. This will
select all of the blank cells in the range. Type = and hit the up arrow and
then type Ctrl Enter. To fix these values use Copy then Paste Special /
Values.
Let me know if I'm a mile off-course!

--
Andy.



doing. I'm trying to create one but the data i have isnt single rows.
Instead it is chunks of rows and columns. For example, i have five columns
and the first column has one thing under it, the next has one, but the next
has three things and the next has one and the last has five things. But
those are all one group of data because they all belong to whats listed in
the first column. Can anyone understand what i mean?

 

[Harry Bo]

Cindy,

If the different ranges of data you have the same headings you can use the "Multiple consolidate ranges in step 1 of the pivot table wizard.

Harry