Forum Discussion

mamunxv8's avatar
mamunxv8
Icon for Helper I rankHelper I
2 years ago

Heading Wise Column

Hi,   I want to transform this dataset column wise. For example, Here is a heading under All Category. Under All Category, there are some data. There are more than 15 headings like All Category. I ...
Need Help
Tips and Tricks
Tutorial Requests
mamunxv8's avatar
mamunxv8
Icon for Helper I rankHelper I
2 years ago

I get this file every day in txt format. Here is the file Dataset

This is the original file.

 

Thanks

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    2 years ago

    mamunxv8 

    You need to specify what is expected output, may be on an Excel sheet. You file has a lot of details.

    • mamunxv8's avatar
      mamunxv8
      Icon for Helper I rankHelper I
      2 years ago

      Fowmy, I want the final output to be like this. Please take a look: Output Data Sample .

      Here are some sample data for 2 headings. On the txt file, there are more than 15 headings.

       

      Thanks