0

Grouping Item No in 1 cell

Zulfadzli

May 16, 2023 10:24

None

Follow

Hello Everyone, 

Seeking your expertise. How do I get all data for Pipe No. without create new line/row in report? below is my line;

=NL("Rows","Packing List Line","Pipe No.","Item No.",$F23)

 Can you guys help me?

Thanks

Pali

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  CascadiaDataworks May 16, 2023 17:35

  Can you provide an example of what you expecting to see?  You are specifically asking for Rows for each Pipe No. for that Item No.  

  If there is more than one Pipe No., you will get multiple rows.

• 0
  
  Zulfadzli May 17, 2023 00:30

  Hi Bryan, 

  My expectation is to get like this
  
  Pipe No. : 0001/0002/0003/0004/0005

  instead of like this;

  Pipe No.

  0001

  0002

  0003

  0004

  0005

   

  I tried use column, but the result is, will create multiple column instead of 1 column.

• 0
  
  Cat May 17, 2023 06:25

  Hi Zulfaduli,

   

  try it like this:

  =NP("Join",NL("Filter","Packing List Line","Pipe No.","Item No.",$F23),"/")

   

  Does that work for you?

• 0
  
  Zulfadzli May 18, 2023 00:31

  Hi Cat, 

  It Works!! You are amazing. Thank you so much for your help