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!
DhaniCole's avatar
DhaniCole
Brass Contributor
Apr 28, 2020

CPSR13 

You can do this with Power Query (under data tab, "From Text/CSV").

If you provide an example of the text document (as .txt), I can see if I can figure it out.

  • CPSR13's avatar
    CPSR13
    Copper Contributor
    Apr 29, 2020

    Attached!  I wasn't able to pull into individual columns, but am grateful for another set of eyes! DhaniCole 

Resources