Merging Rows

[roystanding]

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 solution]

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. 

[roystanding]

Luke,

Thanks for this! It's exactly what is needed. To your question below the data will always be structured as below so this is a perfect solution to my question. I appreciate it. Looks like I need to brush up on my multi-row formula tool knowledge.

Thank you!