Forum Discussion

amien's avatar
amien
Icon for Post Patron rankPost Patron
10 years ago
Solved

Split column not into seperate columns but in rows

how is this possible?    For example:   id, Column 1,A;B;C should become:   id, Column 1, A 1, B 1, C
  • Anonymous's avatar
    Anonymous
    10 years ago

     

    Hi amien,

     

       to solve your problem step by step, you have to:

     

    1) Select the column

     

    2) Split columns by delimiter (comma)

     

    3) Do the transpose (columns become rows & rows become columns)

     

    4) Split columns by delimiter (semicolon)

     

    5) Replace the null values with the chosen values

     

    6) Redo the transpose

     

    ( . . . )

    Let me know if it works.

     

    Have a good coding

     

MACKnox's avatar
MACKnox
Icon for Advocate I rankAdvocate I
8 years ago

It's been some time now, and, columns can be split directly into rows with one step:

 

kabollma's avatar
kabollma
New Member
6 years ago

Hi,

 

I am attempting to use this option. The window that pops up looks exactly like your image, but the option for columns or rows in the middle is just missing. The original choices from Get & Transform only allowed From Table. There was no From Table/Range option. Any direction you might provide would be so helpful.