transpose cols to rows excel 2003 looping macro help please

D

DianneZ

My data starts like this:
------------------------
Items 1 to 398 6-Dec 7-Jan 7-Feb
searches(mm)
Total 39,497 51,854 51,107
All qSearch Properties ... ... ...
Total 39,497 51,854 51,107
[P] Google Sites 27,669 29,761 29,881
[P] Yahoo! Sites 8,176 8,522 8,129
[P] Microsoft Sites 1,824 1,974 1,913
[P] eBay ... 1,343 1,315
------------------------------
I have data as shown above - I'd like to work with it an a pivot table. For
each date column (usually there are 12 date columns), I 'd like to insert a
row and copy down the descriptive data. so that it ends up as shown below.
I have four blocks of data that I would like to run this macro on. How can I
set it to start from the active cell and then stop at blank rows?
--------------------------------------------

Items 1 to 398 items kpi month amount
[P] Google Sites Searches (MM) Dec-06 27,669
[P] Google Sites Searches (MM) Jan-07 29,761
[P] Google Sites Searches (MM) Feb-07 29,881
[P] Google Sites Searches (MM) Mar-07 33,807
[P] Google Sites Searches (MM) Apr-07 33,162
[P] Google Sites Searches (MM) May-07 35,203
[P] Google Sites Searches (MM) Jun-07 36,369
[P] Google Sites Searches (MM) Jul-07 36,559
[P] Google Sites Searches (MM) Aug-07 37,094
[P] Google Sites Searches (MM) Sep-07 38,249
[P] Google Sites Searches (MM) Oct-07 42,398
[P] Google Sites Searches (MM) Nov-07 41,814
[P] Google Sites Searches (MM) Dec-07 41,345
[P] Yahoo! Sites Searches (MM) Dec-06 8,176
[P] Yahoo! Sites Searches (MM) Jan-07 8,522
[P] Yahoo! Sites Searches (MM) Feb-07 8,129
Yahoo! Sites Searches (MM) Mar-07 8,817

Thank you so much!
 
D

DianneZ

Fantastic!!!
Thank you Thank you what a time saver!

Bernie Deitrick said:
Dianne,

Visit John Walkenbach's site:

http://www.j-walk.com/ss/excel/usertips/tip068.htm

for a technique to create a database from a summary table.

HTH,
Bernie
MS Excel MVP


DianneZ said:
My data starts like this:
------------------------
Items 1 to 398 6-Dec 7-Jan 7-Feb
searches(mm)
Total 39,497 51,854 51,107
All qSearch Properties ... ... ...
Total 39,497 51,854 51,107
[P] Google Sites 27,669 29,761 29,881
[P] Yahoo! Sites 8,176 8,522 8,129
[P] Microsoft Sites 1,824 1,974 1,913
[P] eBay ... 1,343 1,315
------------------------------
I have data as shown above - I'd like to work with it an a pivot table. For
each date column (usually there are 12 date columns), I 'd like to insert a
row and copy down the descriptive data. so that it ends up as shown below.
I have four blocks of data that I would like to run this macro on. How can I
set it to start from the active cell and then stop at blank rows?
--------------------------------------------

Items 1 to 398 items kpi month amount
[P] Google Sites Searches (MM) Dec-06 27,669
[P] Google Sites Searches (MM) Jan-07 29,761
[P] Google Sites Searches (MM) Feb-07 29,881
[P] Google Sites Searches (MM) Mar-07 33,807
[P] Google Sites Searches (MM) Apr-07 33,162
[P] Google Sites Searches (MM) May-07 35,203
[P] Google Sites Searches (MM) Jun-07 36,369
[P] Google Sites Searches (MM) Jul-07 36,559
[P] Google Sites Searches (MM) Aug-07 37,094
[P] Google Sites Searches (MM) Sep-07 38,249
[P] Google Sites Searches (MM) Oct-07 42,398
[P] Google Sites Searches (MM) Nov-07 41,814
[P] Google Sites Searches (MM) Dec-07 41,345
[P] Yahoo! Sites Searches (MM) Dec-06 8,176
[P] Yahoo! Sites Searches (MM) Jan-07 8,522
[P] Yahoo! Sites Searches (MM) Feb-07 8,129
Yahoo! Sites Searches (MM) Mar-07 8,817

Thank you so much!
Click to expand...
Click to expand...
 
Top