Merge rows per header

[AvailableUsername]

Hi all,

I'm struggling with some organisation under headers. Perhaps an illustration is worth more than words.

What I have:

Header 1 -  data 1 - data 2 - data 3 - X

null         -      null  -  null   -   null    -  Y

null         -      null  -  null  -     null   -  Z

What I need:

Header 1 - data 1 - data 2 - data 3 -  X -  Y - Z

I would need all the data following on a header to be on the same row as that header.

Could I get some assistance with this? 

Many thanks

[DavidP · Accepted solution]

Could you attach some sample data?

[AvailableUsername]

Hi, thanks for the quick reply.

Unfortunately I can't without breaking the database TOS, but here's a dummy for this purpose

I would need the 'Datapoint' data to end up in the same rows as the company it's assigned to.

[DavidP · Accepted solution]

How about this?

[estherb47 · Accepted solution]

Hi @AvailableUsername 

Similar approach to @DavidP, I just filled in the Company name and a data Point header with multi-row formula tools. A crosstab tool turns those vertical rows into horizontal.

Cheers!

Esther

[AvailableUsername]

Thank you all very much. Both solutions work!

Have a nice day :)