Spreadsheet Re-organization
hi
am i save to assume the your data is currently layed out like this.....+
john smith Item 1
vic stone Item 1
vic stone Item 2
adam smith Item 1
adam smith Item 2
adam smith Item 3
adam smith Item 4
FSt1
"Spreadsheet reorganization" wrote:
I have a table of sales.
It is organized as follows:
1st column: name | second column: Item bought
This table is about 30,000 lines long. If I want to show the data in a
totally separate table in this fashion: one line per last name and all the
"items bought" going across in columns 3, 4, 5, etc (depending on how many
items they bought) what is the best way to reorganize this data in either
excel/access?
|