ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can you help me use VBA to stack data in Excel 2007? (https://www.excelbanter.com/excel-programming/446790-can-you-help-me-use-vba-stack-data-excel-2007-a.html)

Ana Bosak

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