Hi,
my
name
is
Ã
ke Ãhrlund .
I
work
at
Galderma
in
Uppsala
in
Sweden.
I've
been
using
JMP
for
many,
many
years,
almost
my
whole
working
life
so
far,
but
apparently
I'm
still
learning.
That's
what
I
want
to
share
today.
One
of
the
things
I've
come
to
realize
more
late
is
I've
spent
too
much
time
working
on
data,
preparing
it
for
getting
into
JMP
in
Excel; c
utting
and
pasting.
I
want
to
show
you
an
example
how
you
can
do
that
much
faster
in
JMP.
I
got
this
data
set
from
a
colleague
of
mine.
It
was
a
Tensile
testing
data.
It
was
92
runs,
each
one
3900
rows
of
data.
It
was
layout
like
this
with
four
columns
for
each
run,
so
444, 92
times.
On
row
number
three
there
was
a
sample
name
crammed
in
and
then
the
third
900
rows
of
data.
I
couldn't
pick
it
directly
into
JMP,
so
she
said,
"You
want
me
to
cut
and
paste
it
to
be
in
same
columns
like
you
used
to
in
JMP?"
I
said, "N
o.
I'm
going
to
try
to
do
it
directly
JMP."
This
is
what
I
did.
I
started
by
importing
the
data
leaving
out
row
number
three.
I
just
have
to
tell
JMP
that
is
two
header
rows
and
it
should
skip
row
number
three
and
start
on
row
number
four.
Do
that
and
I
have
all
the
data
with
the
two
rows
of
header
on
top.
But
now
this
is
a
white
table
so
I
want
to
stack
this.
S
elect
all
the
columns,
put
them
into
stack.
Now
I
have
to
tell
JMP
there's
four
of
these
columns
that
go
together,
and
JMP
actually
seems
to
get
four
by
four
the
way
they
should
be.
I
just
click
okay,
and
then
I
have
a
table
containing
all
the
data,
a
lot
of
data
rows
stacked
on
top
of
each
other.
I
only
have
four
columns
actually
containing
the
data
and
four
columns
called
label
that
described
what
is
in
those
data
columns.
I could
be
working
from
here,
but
rather
also
have
the
sample
name
there.
Do
the
import
again;
st
art
all
over.
This
time
I
want
row
number
three
still
including
both
header
rows
and
include
row
number
three,
so data
states
starts
here.
Click
next,
and
then
I
have
to
tell
you
that
you
could
skip
everything
after
row
three.
There
you
go.
You
have
one
row
of
data
containing
the
sample
names.
Still
this
is
wide
so
I
want
it
in
the
long
version
like
I
have
with
the
data
table,
so do
stack
again.
Select
all
the
columns
in
to
stack.
This
time
I
don't
have
to
tell
JMP
anything,
just
stack
what
you
have
there.
There
you
have
it.
Another
data
table
with
all
the
sample
names
here.
I
named
this
one
Sample.
This
one
I
can
match
with
the
original
data
table.
That's
what
I'll
do.
I
go
to
the
data
table,
it's
named
Untitled
Three.
Then
I
go
to
update,
and
in
update
I
say,
"Update
with
data
from
Untitled
Six."
What
should
I
take
from
there?
Selected the
columns,
sample,
replace
nothing
in
the
old
data
table
and
now
I match
the
label
here
with
label
here.
Click
okay
and
I
end
up
with
a
data
table
with
all
the
data
and
all
the
sample
names.
Again,
I
could
work
from
here
but
since
this
was
quite
fast
I
want
to
tidy
up
a
bit.
I
want
these
labels
to
go
up
here,
this
label
to
go
up
there
and
so
on.
J
ust
copy
these
and
go
down
here
and
paste
them
into
the
data
two,
data
three,
data
four.
They
end
up
here.
After
doing
that,
I
don't
need
the
label
columns
anymore.
I
can
just
remove
those.
Now
I
have
all
the
data
in
their
columns
headings
with
the
right
column
headings
and
the
sample
name
here.
Now,
of
course,
this
is
where
the
actual
fun
begins.
It's
very
easy
now
to
pick
out
certain
samples
and
do
what
not.
That's
the
fun
part
of
JMP,
of
course.
What
I
conveyor
here
is
try
not
wasting
too
much
time
in
Excel
cutting
and
pasting
because
chances
are
you
might
as
well
do
it
in
JMP
in
much, much
less
time.
I've
been
using
JMP
for
many, many
years
and
still
trying
to
realize
all the
stuff
you
can
do
so
I'm
going
to
try
this
a
lot
more.
That's
all
from
me
today.
Thank
you
very
much
for
listening.
