Is there a quick way to compare / convert data that is arranged in two different manners.
The first set of data I have contains all variables in each row. For example, each row has The Sales Person, State, and Amount
The second set is more of a cross tab with one variable in each row and with the columns across. So the Rows would be States, the Columns are Sales People and the amounts in each cell.
I have several large spreadsheets, with a 50/50 split as to how the data is displayed. I need to take the data from each spread sheet, calculate it and then display it in the firstmanner (all variables in each row)