Power Query: pivot column with text as value field

[tombamber]

Hi

I want to use Power Query to pivot a set of data, but instead of the value cell being a number, it is text.

I need to turn this:

into this:

This is just an example of how the data is setup, using PQ does work for this data, but when I try it with my actual data I get the following error:

Expression.Error: We cannot convert the value null to type Text.
Details:
Value=
Type=[Type]

Thanks

 

[ExcelToDAX]

You just need to transpose the columns. Assuming your Excel table is called "Table1", you could do the following:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Transposed Table" = Table.Transpose(Source),
    #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true])
in
    #"Promoted Headers"

 

[tombamber]

Hi

I want to use Power Query to pivot a set of data, but instead of the value cell being a number, it is text.

I need to turn this:

View attachment 103865

into this:

View attachment 103866

This is just an example of how the data is setup, using PQ does work for this data, but when I try it with my actual data I get the following error:



Thanks

I figured out there is a blank/null row in the questions column which was causing the issue.

I've removed null now and it works.