Forum Discussion

CPSR13's avatar
CPSR13
Copper Contributor
Apr 28, 2020
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 ...
excel
  • CPSR13's avatar
    CPSR13
    Apr 30, 2020
    Someone was able to use IF, sumifs formulas & pivot tables to convert the data for me. I appreciate your reply!
CPSR13's avatar
CPSR13
Copper Contributor
Apr 29, 2020
It's an internal program and this forum doesn't allow for a txt upload
mathetes's avatar
mathetes
Gold Contributor
Apr 29, 2020

CPSR13 

It's an internal program and this forum doesn't allow for a txt upload

 

But you can copy a portion of the text itself, which you do get, to Word, and then upload that Word docx containing editable text content.

Resources