Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Split single cell data into multiple colums | Excel Discussion (Misc queries) | |||
Plotting multiple Y column data versus single X column in Excel 20 | Charts and Charting in Excel | |||
column data retrieved based on value in header row | Excel Discussion (Misc queries) | |||
Copy data from other worksheet based on column header | Excel Discussion (Misc queries) | |||
Split data from 1 workbook into multiple workbooks based on criter | Excel Worksheet Functions |