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]

[TABLE="width: 673"]
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD]matter id[/TD]
[TD]cl sort matter descrps[/TD]
[TD="colspan: 2"]area of law[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]managing none[/TD]
[TD]1/001[/TD]
[TD]client1matter1[/TD]
[TD]admin[/TD]
[TD]managing none[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1/002[/TD]
[TD]client2matter1[/TD]
[TD]family[/TD]
[TD]managing none[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1/003[/TD]
[TD]client3matter2[/TD]
[TD]criminal[/TD]
[TD]managing none[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]managing bill jones[/TD]
[TD]2/101[/TD]
[TD]client4matter3[/TD]
[TD]family[/TD]
[TD]managing bill jones[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2/102[/TD]
[TD]client5matter4[/TD]
[TD]criminal[/TD]
[TD]managing bill jones[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2/103[/TD]
[TD]client5matter6[/TD]
[TD]family[/TD]
[TD]managing bill jones[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"]is this very simplified layout what you want ?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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