Data transformation- transpose fields

Question

I have a table which is similar to this.

StateItemType of saleUnits SoldCABooksRetail50CABooksWholesale500MIBooksRetail20MIBooksWholesale250CTBooksRetail100MABooksRetail100

I would like to transform my data to this:

ItemType of SaleCAMICTMABooksRetail502000BooksWholesale500250100100

Can someone help me to do this?

neilgallen · Accepted Answer

@hash9 This is a pretty simple setup with a cross-tab tool

If you want your table to include zeroes where there is no data then include a data cleanse tool after the cross tab.