Merging Rows

Question

Afternoon,

I'm trying to transpose/merge rows but am running into some trouble. From the picture below, I'd like to get the columns from row 2 to be new columns on row 1 and so on. I.e. data from row 2 would be transposed to row 1, row 4 data would be transpose to new columns on row 3, etc. Any help will be greatly appreciated

Thank you!

Luke_C · Accepted Answer

Hi @roystanding

Here's one approach using the multi-row formulas. This assumes that the data is structured like your example, where the row needed is right below, and that column 6 is always null.

If there's a way that we can connect row 1 to row 2 via some sort of ID I think there are definitely ways to make a more robust solution.