Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique adding of cell from .csv to .xsl????anyone?
Hi All, I append a .xsl file from .csv file daily. In one csv file data comes in following format: Date Time Value1 01/12/04 9:30 234324 01/12/04 10:30 312312 01/12/04 11:30 561345 01/12/04 12:30 671466 01/12/04 13:30 684564 01/12/04 14:30 234564 I want to update this data to an .xsl file in following format: Date 9:30 10:30 11:30 12:30 13:30 14:30 01/12/04 234324 312312 561345 671466 684564 234564 I was trying this so hard, tried it with vlookup and other funtions but couldnt do it. can anyone point me towards right direction for doing this. Many thnks in advance. Sun sun1234 ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message274834.html |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique adding of cell from .csv to .xsl????anyone?
Seems like a pivot table is your answer here. A pivot table can use data and
use it as a field names, that is the Time values can become column headers (fields) TTFN JMMach, MCSC "sun1234" wrote in message ... Hi All, I append a .xsl file from .csv file daily. In one csv file data comes in following format: Date Time Value1 01/12/04 9:30 234324 01/12/04 10:30 312312 01/12/04 11:30 561345 01/12/04 12:30 671466 01/12/04 13:30 684564 01/12/04 14:30 234564 I want to update this data to an .xsl file in following format: Date 9:30 10:30 11:30 12:30 13:30 14:30 01/12/04 234324 312312 561345 671466 684564 234564 I was trying this so hard, tried it with vlookup and other funtions but couldnt do it. can anyone point me towards right direction for doing this. Many thnks in advance. Sun sun1234 ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message274834.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a unique identifier to a column of data | Excel Worksheet Functions | |||
How to keep unique row ht. fixed when adding add'l rows or moving | Excel Discussion (Misc queries) | |||
Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
Adding Unique Items to a Collection | Excel Discussion (Misc queries) | |||
a unique cell value returns multiple cell values from another shee | Excel Worksheet Functions |