|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 7th 12, 02:08 PM
|
|||
|
|||
Can you help me use VBA to stack data in Excel 2007?
I currently have 4 time periods in column A (rows 1 through 4), and the scores for Questions 1 through 23 in columns B through X (same 4 rows). I need to end up with Column A stating Question 1-23 (23 rows), and with Columns B through E being the 4 time periods. Cells B2 to E24 would be the scores. I hope this is a good explanation. This would save me HOURS of work, as I have to repeat this exercise for 10 regions and many groups within each region. Thank you so much!
I have attached my spreadsheet (I only show up to Q10 to save space): 
|
| Ads |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I stack data in Excel 2007? | Ana Bosak | Excel Discussion (Misc queries) | 1 | August 7th 12 05:03 PM |
| Easy way to stack column data? | colleen | Excel Worksheet Functions | 1 | July 7th 08 12:06 AM |
| Multiple data in stack column chart | SMueller | Excel Discussion (Misc queries) | 1 | July 1st 06 02:28 AM |
| How do I set up imported data to stack info within a cell? | bobwms | Excel Discussion (Misc queries) | 1 | June 15th 06 07:48 PM |
| How do I set up imported data to stack info within a cell? | bobwms | Excel Discussion (Misc queries) | 0 | June 15th 06 07:32 PM |
Linear Mode
