xlsx - Excel data organized in multiple nested rows, can R read it? -
please see picture. i've started using r, , know how/that can read files excel, can read formatted this? http://www.flickr.com/photos/68814612@n05/8632809494/ (my apologies, upload not working me) elaborating on of what's in comments: if load file excel, can save fixed-width or comma-delimited text file. either should easy read r. the following may obvious already. (first, question: sure can't data in format has 1 set of data per line? possible file you're getting generated different file format more conducive loading data r?) whether should start rearranging data in r or instead manipulate raw text depends on comes naturally (or people have around can help). me, personally, rearrange text file outside of r before loading r. that's what's easiest me. perl great language purpose, unix shell scripts if that's accessible you, or using powerful editor such vim or emacs. if have no preference, i'd suggest perl. if have signifi