I need to organize a spreadsheet of log files into specific columns. The spreadsheet is a converted text column, each log file parses things differently, so column 'a' on one row can be userid, while column 'd' on row is the userid.
I want to organize this spreadsheet, so that column a is userid for all logs. is there a specific excel formula or macro i should use, i was thinking:
if cell contains userid, move to column 'x'. just not sure how to do this.
posted by fozzie33
on Mar 29, 2010 -