Comparing Data in Two Different Arrangements

[tc177]

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)

[stanleydgromjr]

tc177,

Welcome to the Excel Forum.

Please post your workbook.

Click on New Post, then scroll down and see Manage Attachments.

[tc177]

Here is an example of the two arrangements....

Obviously, the pivot can be usesd to convert the list arrangement to the array, but I need to ultimately have a list.

[tc177]

Sorry here it is

[stanleydgromjr]

tc177,

What is the actual worksheet name for the sheet your have named "Line by Line"?

Is it Sheet1??????

Can we have the results you are looking for in the same worksheet where the raw data is?????

[stanleydgromjr]

tc177,

Detach/open workbook AdvancedFilter Unique State and Code - SUMPRODUCT - tc177 - SDG13.xls, and and run macro CreateResults.