Convert Column Data to Row

sgnarkhede2016

Hello ,
I have 
Data:
Value                             Attribute

?		Count
4.0		MONTH
15.0		WEEK_OF_YEAR
2022.0		YEAR
1633.1286847639503		prediction(Count)
?		Count
4.0		MONTH
16.0		WEEK_OF_YEAR
2022.0		YEAR
1674.7535102732875		prediction(Count)

Expected output
Count MONTH WEEK_OF_YEAR YEAR prediction(Count)
?          4.0         15.0                        2022 1633.128   

Can anyone help me on this

MartinLiebig

Hi,

sounds like the transpose operator is your thing.

BR,

Martin