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
Solved! Go to Solution.
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.
Find your favorite faces from the community presenting at the Power Platform Community Conference!
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Join this community-driven Power Platform digital event for unbiased support and problem-solving.