| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
transpose cols to rows excel 2003 looping macro help please
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
transpose cols to rows excel 2003 looping macro help please
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" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
transpose cols to rows excel 2003 looping macro help please
Fantastic!!!
Thank you Thank you what a time saver! "Bernie Deitrick" wrote: 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" wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003: Transpose (flip, swap, rotate) rows and cells. | Excel Worksheet Functions | |||
| Can I transpose data from rows to cols with a formula not pivot ta | Excel Worksheet Functions | |||
| Excel Macro to transpose addresses from rows to columns | Excel Programming | |||
| create macro - pivot table Select all rows/cols with data less las | Excel Programming | |||
| Macro to Transpose 1 col into 3 cols | Excel Programming | |||
Linear Mode
