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,