Forum Discussion
Solved
Grouped text conversion to columns in Excel
I have report data in notepad .txt format that is grouped by employee. I need to convert to columns in an Excel spreadsheet. There are 12477 lines...is there a way to do it without having to perform ...
- Someone was able to use IF, sumifs formulas & pivot tables to convert the data for me. I appreciate your reply!
It's an internal program and this forum doesn't allow for a txt upload
IMHO, two main points to clarify
- logic of input file. Is it with fixed width columns or not. If so, how many characters in each column. If not, what the logic. What are flexible -why employee ID/name sometimes in first position, sometimes not, what are the options.
- logic of output. Are employees ID and name in first two columns and all few dozens of other ID:s in other columns or not. Shall they be separated on 4 groups (Pay, Deduct, etc) or not. If yes, when how.
- All data was in one column when converted or opened in Excel. All possible field identifiers needed to be in columns. Someone was able to use IF, sumifs formulas & pivot tables to convert the data for me. I appreciate your reply!
Thanks, but I'm asking not about how it looks if to open in Excel - how data are separated in text file, is that fixed number of characters for each column or what.