Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I 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 an example (I only show up to Q10 to save space). THANK YOU! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stack data in Excel 2007?
On Tuesday, August 7, 2012 8:04:59 AM UTC-5, Ana Bosak wrote:
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 an example (I only show up to Q10 to save space). THANK YOU! +-------------------------------------------------------------------+ |Filename: Example Data I need to stack.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=525| +-------------------------------------------------------------------+ -- Ana Bosak in cell b4 copied across and then down =INDEX($A$12:$E$25,COLUMN(B1),MATCH($A4,$12:$12)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy way to stack column data? | Excel Worksheet Functions | |||
Multiple data in stack column chart | Excel Discussion (Misc queries) | |||
Multiple data in stack column chart | Charts and Charting in Excel | |||
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) |