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

Click the below link and download the file

http://www.mediafire.com/?mzlho5znrmn

Sheet1 is having your first data.
Sheet2 is retreiving the data from sheet1 which you are expected to do.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"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

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