Query: Assigning Rows to columns

[JAgius]

 Hey Guys,

i have two queries and have to combine them. One are the Headers for the desired Columns and in my other i have all the data just in one Column. They are 24 Columns and the Value of Row1 has to be combined to Column1 , Row2 to Column2.... Row25 to Column1.....

Is this possible ? Thanks in Advance

[v-jiascu-msft]

Hi @JAgius,

Could you please mark the proper answer as solution or share the solution if it's convenient for you?

Best Regards!
Dale

[v-jiascu-msft]

Hi @JAgius,

Two approaches here. If you are familiar with R, you can try the approach 1. 

1. R code.

# 'dataset' holds the input data for this script
c <- dataset$Value  
length(c) <- prod(dim(matrix(c, ncol = 24))) # this step will insert null instead of recycling.
temp <- matrix(c, ncol = 24, byrow = T)
result <- data.frame(temp) # Power BI accept data frame.

2. Using pivot function. Please check out this file. 

Best Regards,

Dale