Forum Discussion
Repeat Cell Values
Hello all, I am trying to transpose data in a way that is more readable for a software I will be using. I have attached an image that contains what the current table looks like, and then the des...
Formula version:
=DROP(
REDUCE(
"",
letters,
LAMBDA(a, v,
LET(
val, XLOOKUP(v, letters, data),
SORT(VSTACK(a, HSTACK(labels, EXPAND(v, ROWS(val), , v), val)), {1, 2})
)
)
),
1
)
For a large data set use the PowerQuery solution!