xml transforms to rearrange worksheet data?

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top