data transpose function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to transpose data using VBA programming. Here is the example:

original data set:

Item Jun04 Aug04 Sep04
aaaa 10 9 11
bbbb 8 11 12

Transpose into a new worksheet

Item Month/year Qty
aaaa 7/2004 10
aaaa 8/2004 9
aaaa 9/2004 11
bbbb 7/2004 8
bbbb 8/2004 11
bbbb 9/2004 12

We can always use recordset to house a set of data and pass the recordset
aroud between tables in Access . How can I handle this in Excel and get data
paste into another worksheet?

Your assistance is highly appreciated,

Jackie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transposing 0
Move cells down to match cells 3
Move cells down to match cells 1
Multiple rows into one cell 8
variable cell referencing for simple data points 4
I need to help with Excel (beginner) -- year row and month column 2
Excel 2003: Copy rows from one workbook into another without losinginterleaved data 3
Gears 14

Back
Top