![]() |
Can you help me use VBA to stack data in Excel 2007?
1 Attachment(s)
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): |
All times are GMT +1. The time now is 08:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com