M
mcarter
I have a table with fields f1, f2, f3, name1, name2, name3, name4, f4, f5.
I need the table to look like f1, f2, f3, name, f4, f5 where it would list
the
name1-name4 in rows instead of columns. (ie reverse crosstab).
How do I transpose this table so that the names are in 1 field (in 4 rows)
instead of
4 separate fields in 1 row?
Thanks in advance!
I need the table to look like f1, f2, f3, name, f4, f5 where it would list
the
name1-name4 in rows instead of columns. (ie reverse crosstab).
How do I transpose this table so that the names are in 1 field (in 4 rows)
instead of
4 separate fields in 1 row?
Thanks in advance!