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! |
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 |