cancel
Showing results for
Did you mean:
Highlighted
Helper III

## convert 1 column into 4 columns

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III

## Re: convert 1 column into 4 columns

Hi @Bbrown44 ,

Ricardo

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

5 REPLIES 5
Highlighted
Super User IV

## Re: convert 1 column into 4 columns

@Bbrown44 , try Pivot

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper III

## Re: convert 1 column into 4 columns

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.

Highlighted
Super User IV

## Re: convert 1 column into 4 columns

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())

do not hesitate to give a kudo to useful posts and mark solutions as solution
Highlighted
Super User III

## Re: convert 1 column into 4 columns

Hi @Bbrown44 ,

Ricardo

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helper III

## Re: convert 1 column into 4 columns

Thanks!

this works as well.

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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (854)