Excel Node Data - Combine 2 rows into 1

Follow

andrew darnell

• July 03, 2020 03:51

Hi Guys,

I've got a lot of data within an xlsx file but the source system didn't out the whole transaction in one single line. It has split the other columns onto the following line, transaction are separated via a blank line.

I've attached the example of what my data looks like in excel for 2 transactions

 

Attached files

example.xlsx

What i need the data to end up looking like is as per below

results.xlsx

I'm hoping that someone can help me out with this..

 

0

• 

  Adrian Williams

  • July 07, 2020 08:39

  Here is an example of how you can combine the data from the two records.

  In Lavastorm all fields must have a non-Null field name so you cannot output completely Null columns to an Excell file.

   

   

  Attached files

  Join_Records.brg

   

  0

  Comment actions Permalink

Please sign in to leave a comment.