Well, it's good to know that - thanks for feeding back.

Pete

On Jul 24, 6:38*am, T Magritte wrote:
In this case the data comes from a mouse microarray which is a
technology that can measure (more or less) the expression of genes
(basically, all the genes) of a mouse. Of course there are similar
arrays for humans and other species. This one is an exon array, so it
detects expression of individual exons within each gene. (Genes can
express multiple exons that can be arranged in different ways so that
a number of different proteins can be produced from the same gene.)
This, of course, adds a lot more data to the mix...

So in this particular example I'm looking at 25 mice (25 rows) and a
core set of genes that have combined a little under 20 k exons
(columns). (Actually, if you look at the complete array there's more
like a million exons but then the amount of data starts to get really
ridiculous for Excel.)

If you merge the exon data into gene level data there's a little over
16 k genes. So in that case you can almost import the whole data set
into a sheet but it turns out there's a little bit over the column
limit still.

As I said, if I transpose the data before importing into excel so that
there are only 25 columns, it's fine. But it would be better if that
didn't have to be done.

Really, I'm still learning how to do this stuff. There are software
packages more appropriate for dealing with this type of data and
analysis but since I'm much more familiar with Excel I have this
tendency to fall back to it for a lot of quick and dirty stuff.
Despite it's limitations it's a very useful tool and I just wish it
could be more versatile for large sets. But I guess there isn't enough
of a market for an Office Science Edition...

Thanks.

On Jul 23, 7:27*pm, Pete_UK wrote:



I think we'd all like to know that. <g

Pete

On Jul 23, 10:48*pm, dlw wrote:

May I ask what kind of data record has 200K fields?- Hide quoted text -

- Show quoted text -