Best way to report data

[michael.blaustein]

Hi,
I have some data, it looks like this:

X A 1
X B 1
X C 2
X D 1
Y A 2
Y B 2
Y C 1
Y D 3
Z A 1
Z B 4
Z C 3
Z D 7

I would like it to look like this:

A B C D
X 1 1 2 1
Y 2 2 1 3
Z 1 4 3 7

So, essentially, I want to make column 2 into a column header. Any
ideas how I can accomplish this? Thanks,
Michael

 

[Mike Middleton]

(e-mail address removed) -

If the data are in three separate columns, you could put a field name at the
top of each column and use a pivot table to get the report.

If the data are in a single column, first use Data | Text To Columns (with
space as the separator).

- Mike
www.mikemiddleton.com