| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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): |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stack data in Excel 2007? | Excel Discussion (Misc queries) | |||
| Easy way to stack column data? | Excel Worksheet Functions | |||
| Multiple data in stack column chart | Excel Discussion (Misc queries) | |||
| How do I set up imported data to stack info within a cell? | Excel Discussion (Misc queries) | |||
| How do I set up imported data to stack info within a cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
