Data on multiple rows from Excel file

1

Hi to all,

I have issue with import Excel data which leads to result as shown in attached image: data in one of the column may be, not always, spread in more than 1 row. Expected result is to concatene these rows in one. I tried to use fill down and pivot transformations without succes. Any suggestions welcome…I am pretty convinced this should not be a big issue but I am blocked…

Thanks in avdance to all,

image

2

Hi Arnaud,

You can solve this problem in 2 steps:

  1. Fill down the gaps in columns Date, Amount
  2. Aggregate Description (“Concatenate” function) and Amount (“Any” function)

See the example below:

fill-down-aggregate.morph (2.9 KB)
Book1.xlsx (8.8 KB)

image
image977×321 13 KB