Formula to return Column A Heading

[mcranda256]

https://ibb.co/X3Vz5Sm

I have a data set where column A is a heading. I would like the information in column A to be in column E of each line.

Image of spreadsheet is in the link given above. Also, is this data in tabular format?

Thank you

 

[oldbrewer]

not clear from the screen grab - eg do you want A5 to be replicated in E5

 

[mcranda256]

https://ibb.co/gjtHFQj

Maybe this image will help. All of the headings in column A, I would like in column E under. Column A starts at row 2 and ends at 136. Then, there is another heading. This is how the data is extracted out of my software. It is so frustrating.

 

[oldbrewer]

What do you mean column E under ? Do you want the column A heading for each block of data to be on every row in column E ?

 

[oldbrewer]

	matter id	cl sort matter descrps	area of law
managing none	1/001	client1matter1	admin	managing none
	1/002	client2matter1	family	managing none
	1/003	client3matter2	criminal	managing none
managing bill jones	2/101	client4matter3	family	managing bill jones
	2/102	client5matter4	criminal	managing bill jones
	2/103	client5matter6	family	managing bill jones
	is this very simplified layout what you want ?

<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[mcranda256]

This is exactly what I am after

 

[oldbrewer]

so in column E check if column A is blank - if it is return the cell above in column E - if it is not return the cell in column A

 

[mcranda256]

The attorney is listed in a tabular format. The attorney is listed in column A above the data. For lines 1850 and 1850, In column E I would like it to return Tasa, Maranda. Does this make sense?

 

[mcranda256]

https://ibb.co/BLGxLmz