Forum Discussion

randyrettig's avatar
randyrettig
Helper I
2 years ago
Solved

Column rows to headers

Hi all,   I'm transforming info from a .pdf, and there is a little table on the .pdf that shows up in power query like the picture attached.   How can I make the values in column 1 and column 3 t...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi randyrettig ,

    Based on your question, here are my answers.

    I think you can Transpose the table.

    Then click on the Use First Row as Headers.

    Use Text Filters and enter the codes.

    = Table.SelectRows(#"Changed Type1", each Value.Is(Value.FromText([Total Calls]), Int32.Type))

    Then you will see what you want.

     

     

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    How to Get Your Question Answered Quickly 

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi randyrettig ,

Based on your question, here are my answers.

I think you can Transpose the table.

Then click on the Use First Row as Headers.

Use Text Filters and enter the codes.

= Table.SelectRows(#"Changed Type1", each Value.Is(Value.FromText([Total Calls]), Int32.Type))

Then you will see what you want.

 

 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

How to Get Your Question Answered Quickly 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.