George -

It is very easy if you dump the data into a Microsoft Access table and run a
crosstab query. A crosstab query is a lot like a pivot table, but you can
select Max value for text fields and it will show the text values, where the
pivot table in Excel wants to use numeric results in the value section.

--
Daryl S


"george" wrote:

Hi All,

I have data in three diff columns, e.g:
column A column B column C
1 absman a
1 folklore b
2 internet c
2 absman d
3 folklore e
3 internet f

I want these to be segregated under different heads based on the unique ID
in column A with header (col B) and pull the data in Col C

Result shld be something like this

Headet absman folklore internet
1 a b
2 d c
3

Could ypu please help or I need to run vlookup by splitting the data, I have
17 million rows of data (split in 2 files) to be pulled under 16 heads.

Your help in this regard is highly appreciated.
--
Thanks,
George