Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Split multiple columns into rows at once

I have a table that has 37 columns. each column needs to be split in to rows. If I did that to one by one it is a big mess. I need a code to apply to make it all at once. Here is a sample of the tabl...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Based on the proposed example, this script should do what is required.
    An implicit assumption, for example, is that indexes are unique.
    If something does not work as desired, explain well what by loading the tables (so that they can be copied, not as images) on which it does not work and indicating exactly the error and where it occurs.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Based on the proposed example, this script should do what is required.
An implicit assumption, for example, is that indexes are unique.
If something does not work as desired, explain well what by loading the tables (so that they can be copied, not as images) on which it does not work and indicating exactly the error and where it occurs.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This is amazing! it worked like a charm.

I had to replace nulls first to get it working

= Table.TransformColumns(Source,{},(x) => Replacer.ReplaceValue(x,null,""))

but overall it worked out very well

Thank you very much