Extracting data from a Pivot
 

Hi,

I have data in a pivot format. .
ie.
Column
Row - Data

but I need this information in a list so I can perform an upload from this
data:
ie. . .
Row, Column, Data

Whats the quickest way of getting this information?

Any help appreciated,

Extracting data from a Pivot
 

I'd start by changing the layout of the Pivot... Move the current Column
header to be a second Row header. Then you'll have something like:
Criteria1-A Criteria2-A data
Criteria2-B data
Cirerita2-C data
Criteria1-B Criteria2-A data
Criteria2-B data
etc..

Copy / paste special values to make a fixed (non-pivot) copy of the data.
Then filter / auto-filter. Select (blank) in column A. In the first
selected row in column A, enter a formula to copy the prior cell's value.
Ex: if the first blank selected is A4, enter the formula =a3. Copy that
formula down into all the blank cells in column A within your table. Turn
off the filter and you should be ready to upload.
HTH. --Bruce

"Savillehead" wrote:

Hi,

I have data in a pivot format. .
ie.
Column
Row - Data

but I need this information in a list so I can perform an upload from this
data:
ie. . .
Row, Column, Data

Whats the quickest way of getting this information?

Any help appreciated,

Extracting data from a Pivot
 

Sorry I should have explained . . .I am unable to change the layout as this
is not in a pivot table, but just data entry a pivot format

"bpeltzer" wrote:

I'd start by changing the layout of the Pivot... Move the current Column
header to be a second Row header. Then you'll have something like:
Criteria1-A Criteria2-A data
Criteria2-B data
Cirerita2-C data
Criteria1-B Criteria2-A data
Criteria2-B data
etc..

Copy / paste special values to make a fixed (non-pivot) copy of the data.
Then filter / auto-filter. Select (blank) in column A. In the first
selected row in column A, enter a formula to copy the prior cell's value.
Ex: if the first blank selected is A4, enter the formula =a3. Copy that
formula down into all the blank cells in column A within your table. Turn
off the filter and you should be ready to upload.
HTH. --Bruce

"Savillehead" wrote:

Hi,

I have data in a pivot format. .
ie.
Column
Row - Data

but I need this information in a list so I can perform an upload from this
data:
ie. . .
Row, Column, Data

Whats the quickest way of getting this information?

Any help appreciated,

Extracting data from a Pivot
 

OK, a little more work...
In a separate table, I'd create the first two columns of your upload format:
Criteria1Value1 Criteria2Value1
Criteria1Value1 Criteria2Value2
....

In columns C and D, I'd use the MATCH function to determine where in the
pivot format the values are found. In C2, for example:
=match(a2,PivotSheet!$A:$A,0), and in D2 =match(b2,PivotSheet!$1:$1,0). Then
use those match values to pull the data from the pivot. In E2:
=offset(PivotSheet!$A$1,c2-1,d2-1)


"Savillehead" wrote:

Sorry I should have explained . . .I am unable to change the layout as this
is not in a pivot table, but just data entry a pivot format

"bpeltzer" wrote:

I'd start by changing the layout of the Pivot... Move the current Column
header to be a second Row header. Then you'll have something like:
Criteria1-A Criteria2-A data
Criteria2-B data
Cirerita2-C data
Criteria1-B Criteria2-A data
Criteria2-B data
etc..

Copy / paste special values to make a fixed (non-pivot) copy of the data.
Then filter / auto-filter. Select (blank) in column A. In the first
selected row in column A, enter a formula to copy the prior cell's value.
Ex: if the first blank selected is A4, enter the formula =a3. Copy that
formula down into all the blank cells in column A within your table. Turn
off the filter and you should be ready to upload.
HTH. --Bruce

"Savillehead" wrote:

Hi,

I have data in a pivot format. .
ie.
Column
Row - Data

but I need this information in a list so I can perform an upload from this
data:
ie. . .
Row, Column, Data

Whats the quickest way of getting this information?

Any help appreciated,