Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data from several fles with different subset of rows
Hi, I apologize if this is a really basic question. I'm trying to
import a series of data for 5 years. Each year is a separate file. I'll use a simple example as an analogy. Say I have a store and I track my sales by item. But what I sell changes slightly from year to year, like so: 1975: Pet Rock 20 Guns 10 Butter 25 1990: Pogs 30 Guns 15 Butter 25 2000: Pokemon 10 Guns 20 Butter 30 How do I have the data so it looks like this? 1975 1990 2000 Pet Rock 20 Pogs 30 Guns 10 15 20 Butter 25 25 30 Pokemon 10 I'm sure this question has been answered in some form before so if you can point me in the right direction I'd be grateful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query doesn't add/delete data in rows on refresh | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Loading Column Data with blank Rows into Data Validation Box | Excel Worksheet Functions | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) |