Forum Discussion

PowerBtm's avatar
PowerBtm
New Member
5 years ago
Solved

Help: How could I automatically split a row in two when it passes a certain length?

I need to find a way to transform a single long column of up to 110 rows into multiple columns of maximum 40 rows. A40 to A79 should get moved to B0 to B39, etc. 

 

Here's the kicker; I can't use VBA and any fix can't modify the data of the cells, and I CAN'T convert the column using a delimiter. I can't fraction the data of the cells in two. Can anyone give me any pointers? I'd really appreciate some help or guidance, I'm going crazy.

Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    You can use:

    = Table.FromRows(List.Zip(List.Split(TableName[ColumnName], 40)))

     

    --Nate

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    You can use:

    = Table.FromRows(List.Zip(List.Split(TableName[ColumnName], 40)))

     

    --Nate

  • Jakinta's avatar
    Jakinta
    Solution Sage
    5 years ago

    Maybe this?

     

     

    Table.FromColumns(List.Split(YourTable[YourColumn],40),{"Column1","Column2","Column3"})