Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
re-arranging the data
I have a table, which contains the data in a format like this:
group ID # of office visit A 5 A 9 B 5 B 6 A 7 I want to re-arrange the data, so I can calculate the median, mean, and mode of each group in excel using the data analysis tool. I want the dat to look like this: A B 5 5 9 6 7 How can I do that? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
re-arranging the data
Select the range of data you're looking to rearrange, copy, paste special,
transpose. Dave "Lan" wrote: I have a table, which contains the data in a format like this: group ID # of office visit A 5 A 9 B 5 B 6 A 7 I want to re-arrange the data, so I can calculate the median, mean, and mode of each group in excel using the data analysis tool. I want the dat to look like this: A B 5 5 9 6 7 How can I do that? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
re-arranging the data
That is not the result I want.
If I copy, paste special, and transpose, the result would be: A A B B A 5 9 5 6 7 I want: A B 5 5 9 6 7 Thanks "Dave F" wrote: Select the range of data you're looking to rearrange, copy, paste special, transpose. Dave "Lan" wrote: I have a table, which contains the data in a format like this: group ID # of office visit A 5 A 9 B 5 B 6 A 7 I want to re-arrange the data, so I can calculate the median, mean, and mode of each group in excel using the data analysis tool. I want the dat to look like this: A B 5 5 9 6 7 How can I do that? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |