Raw Data Format (Can QV Re-Organize?)

[#1]

Hi Gang - Question for the general forum. I have raw data reported by our server that isnt exactly an optimal configuration for QV. That is, instead of having two columns for product line revenue (one for product line and one for revenue); the data is combined into one column "product line revenue."

I want to user to be able to simple click the Product Line. Is there a fuction that allows to QV to reorganize the data to the desired format?

Current Format

Product Line A Revenue	Product Line  B Revenue	Product Line C Revenue
$100	$50	$200

Desired Format

Product Line	Revenue
A	$100
B	$50
C	$200

[Anonymous]

Hi Brian,

Is it an excel file?

You should be able to use crosstable to load this the way you want. However, you might have to manipulate the values "Product Line X Revenue" to parse it to just "X".