Only one header

[DanielCarro]

Hi guys,

I need to have just one header, so all on row 1. I tried using multi-row formula but not working

 

I tried using multirow formula but giving me error

 Much appreciated your assistance on this  one.

Kind Regards,

Dan

[TimN · Accepted solution]

If you know how many rows make up the header then maybe something like this...

[binuacs · Accepted solution]

@DanielCarro summarise tool is an option in your case

[Raj]

If all the other values are null you could have just used Summarize tool with longest action.

[CoG]

If you have data and headers in the same table, here is a workflow that can get the job done regardless of where the column headers are, assuming the header is the top value in every column and no data occupies any of the rows where the headers are. Example:

Field 1	Field 2
Null	Header 2
Header 1	Null
Data 1	Data 2

This is a good example since no data values occupy rows where Headers are. Example 2:

Field 1	Field 2
Null	Header 2
Null	Data 2
Header 1	Null
Data 1	Null

Bad example because Data 2 is in a row above Header 1. The workflow will not work properly in cases like this.

To make this process more dynamic and allow for cases like Example 2, a macro is required. But your example makes me think that is not necessary.

[DanielCarro]

Hi @TimN ,

Your solution worked great.

Many thanks,

Dan