Aligning data from different rows

[GosiaK]

Hi, My data is in a format where the description is in row 1 but values in row 2 and 3, or description in line 5 and values in line 6. What would be the best way to align my data into one row or get the descriptions populated in the blank cells below in the same column if the cells are empty?

[Christina_H · Accepted solution]

It's hard to know exactly what will work without seeing your data, but I would try updating the description field with a multi-row formula.  I'm assuming you have some sort of ID field to know when rows refer to the same thing?

if [ID]=[Row-1:ID] then [Row-1:Description] else [Description] endif

[mceleavey]

@GosiaK ,

to help @Christina_H et al, can you provide a mock up of your data (but make sure it's representative of your real data)?

Thanks,

M

[GosiaK]

Thank you @Christina_H the multi-row formula did the trick.