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!
oho my friend, it is a jpeg file you have to share a text file so i may be converted your date use advanced filter format but the requirement is text file
you can simply copy and paste the text in msg if you dont have a file
Hurry up!, i am waiting
you can simply copy and paste the text in msg if you dont have a file
Hurry up!, i am waiting
Someone was able to use IF, sumifs formulas & pivot tables to convert the data for me. I appreciate your reply!
CPSR13 text to column is a best tool to convert this data you have to convert text to column according to deliminiter of tab
- it can be easily done by flash fill