convert 1 column into 4 columns

[Bbrown44]

Hello,

I have data in one row that consist of 4 variables.

What I want is

Every 1st row = Column A

Every 2nd row = column B

Every 3rd row = column c

Every 4th row = column D

So when you get to the 5th row you loop back to

5th row = Column A

 6throw = column B

7th row = column c

8th row = column D

And so on in this loop until the rows of data are exhausted.

See image below as for the structure of data

[az38]

Hi @Bbrown44 

try a column

Column = SWITCH(TRUE(),
MOD([Index], 4) = 0, "Column A", 
MOD([Index], 4) = 1, "Column B", 
MOD([Index], 4) = 2, "Column C", 
MOD([Index], 4) = 3, "Column D", 
BLANK())

[amitchandak]

@Bbrown44 , try Pivot

Refer:https://radacad.com/pivot-and-unpivot-with-power-bi

[Bbrown44]

the Pivot default does not recognize that the data needs to be structure into 4 columns

it pivots all the data long.  so then you have an infinite number of columns from the 1 column.

[camargos88 · Accepted solution]

Hi @Bbrown44 ,

Check this file: Download PBIX 

Ricardo

[Bbrown44]

Thanks!

this works as well.

I was able to find a tutorial to solve this as well.

https://www.youtube.com/watch?v=V_ULyeHNJFY