• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

help required how to split cell

sandeep kelkar

New Member
split the
6 Unit Fodder Grass Bijankur-BB2 50 gm Rs. 370 2 Unit Fodder Grass Alamdar 51 1 kg Rs. 685 into two rows
result should be
6 Unit Fodder Grass Bijankur-BB2 50 gm Rs. 370
2 Unit Fodder Grass Alamdar 51 1 kg Rs. 685
 
text to columns will split entire text in different columns I require text to row this 6 Unit Fodder Grass Bijankur-BB2 50 gm Rs. 370 in 1 row & 2 Unit Fodder Grass Alamdar 51 1 kg Rs. 685 in second row or the next row
 
below is the sample file one with yellow are to be considered as that is split into two rows without disturbing the next row as it contains other order also
 

Attachments

  • sample.xlsx
    13.2 KB · Views: 9
Last edited:
below is the sample file one with yellow are to be considered as that is split into two rows without disturbing the next row as it contains other order also
The OP attachment consist of a lot of single value and multiple value data and carried with duplicate.

Here is a formula to split the multiple value data into separate cells and include removing all duplicate.

In C1, formula copied down :

=IFERROR(FILTERXML("<a><b>"&SUBSTITUTE(TEXTJOIN(CHAR(10),,$A$1:$A$234),CHAR(10),"</b><b>")&"</b></a>","//b[not(preceding::*=.)]["&ROW(A1)&"]"),"")

70890
 

Attachments

  • Split data(BY).xlsx
    15.1 KB · Views: 4
Last edited:
Back
Top