I have converted the excel file to csv and imported the data using R Studio.
This is the file R_format.xlsx <http://r.789695.n4.nabble.com/file/n4684737/R_format.xlsx> I have coded the following: list(R_format$Tasks) list(R_format$Client.Mnemonic) task.freq=table(R_format$Tasks) task.freq cbind(task.freq) I am not sure how to categorize the things. In the excel sheet I have the same tasks done for different client mnemonics. I want to categorize them accordingly and display them in tabular format one after the other. The works are: * Categorize according to Tasks * Syntax for plotting the table with two columns Tasks and ClientMnemonics. thanks!! Ashraf -- View this message in context: http://r.789695.n4.nabble.com/Categorizing-and-displaying-excel-data-in-tabular-format-tp4684711p4684737.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.