Forum Discussion

mamunxv8's avatar
mamunxv8
Helper 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 want to transform them all under the date I received them.

 

 

All Category

    ISSUES ADVANCED                 :                     38
    ISSUES DECLINED                 :                     98
    ISSUES UNCHANGED                :                    171
    TOTAL ISSUES TRADED             :                    307


A Category

    ISSUES ADVANCED                 :                     16
    ISSUES DECLINED                 :                     70
    ISSUES UNCHANGED                :                    115
    TOTAL ISSUES TRADED             :                    201


B Category

    ISSUES ADVANCED                 :                     19
    ISSUES DECLINED                 :                     25
    ISSUES UNCHANGED                :                     47
    TOTAL ISSUES TRADED             :                     91

 

 

Can I do it on Power BI? If I can, how can I do that?

Thanks

 

Need Help
Tips and Tricks
Tutorial Requests

4 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    mamunxv8 

    Could you share the data in Excel using Google Drive and pasting the link here, make sure to grant access to the file. You sample data should represent the actual data for this scenario.

  • mamunxv8's avatar
    mamunxv8
    Helper 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
      Super 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
        Helper 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