I have a transformation in Pentaho (PDI) where I have several rows that the information is Null, but in each of the records there is a top row that has the data, I am using analytic query but for each empty row I have to create a column , I want all records to be considered regardless of how many rows are null.

For column A and B it is how I have the information in column C and D is how the information looks with Analytic Query, I want everything to be in a single column without having to create n number of columns

| Column A | Column B | Column C | Column D |
| Valor 1 | Valor2 | Valor 1 | Nulll |
| Null | Null | Valor 1 | Null |
| Null | Null | Null | Valor 1 |