C
Clif McIrvin
xl2010
Anyone here familiar with using xml transforms to massage xl data?
I have an inherited spreadsheet I'd like to use a pivot table on, but it
is not organized as a list, or table. Seems like I've read that xml
transforms can be used to manipulate how data is presented; I'm
wondering if I can use a transform to create a new worksheet with the
data re-arranged into proper rows and columns.
I've no idea even where to start looking for information --- anyone have
some links or pointers for me?
TIA!
Anyone here familiar with using xml transforms to massage xl data?
I have an inherited spreadsheet I'd like to use a pivot table on, but it
is not organized as a list, or table. Seems like I've read that xml
transforms can be used to manipulate how data is presented; I'm
wondering if I can use a transform to create a new worksheet with the
data re-arranged into proper rows and columns.
I've no idea even where to start looking for information --- anyone have
some links or pointers for me?
TIA!