How to import data like this

[deadfish]

Hi,

I need to import data from Access to Excel like this:

month item qty month item qty
---------------------------------------------------------
2005 01 item1 10 2005 02 item1 2
2005 01 item2 5 2005 02 item2 3
2005 01 item3 2

I would like different area of cell containing data of different months (e.g. column A to C containing the data of 2005 01, column D to F containing the data of 2005 02, column G to I containing the data of 2005 03....)

How to achieve this?

Thanks!

 

[Gavona]

How is your data structured currently?
IF you have just 3 columns (month, Item, qty) currently then once imported a pivot table would almost get you there. You could have Items listed in Col A, then Col B would be for Month1 qty, Col C for month2 qty etc. This actually sounds to me to meet your requirement (and is very simple to achieve)it just is not 100% to your specification.

RowField = item
ColumnField = Month
DatField= Qty



Gavin