Aligning data from different rows

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?

Datasets

Accepted answers

Christina_H

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

All comments

Christina_H

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,

GosiaK

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703