Column rows to headers

[randyrettig]

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 the headers, and then the call info in columns 2 and 4 show in the appropriate rows below?

Thanks!

[Anonymous · Accepted solution]

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.

[Greg_Deckler]

@randyrettig Perhaps try importing Column1 and Column2 as one query and Column3 and Column4 as another. Append the queries and perform a Transpose.