Formula to return Column A Heading

mcranda256

New Member
Joined
Mar 11, 2019
Messages
5
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
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
not clear from the screen grab - eg do you want A5 to be replicated in E5
 

mcranda256

New Member
Joined
Mar 11, 2019
Messages
5
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

Board Regular
Joined
Apr 11, 2010
Messages
11,003
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

Board Regular
Joined
Apr 11, 2010
Messages
11,003

ADVERTISEMENT

matter idcl sort matter descrpsarea of law
managing none1/001client1matter1adminmanaging none
1/002client2matter1familymanaging none
1/003client3matter2criminalmanaging none
managing bill jones2/101client4matter3familymanaging bill jones
2/102client5matter4criminalmanaging bill jones
2/103client5matter6familymanaging bill jones
is this very simplified layout what you want ?

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

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003

ADVERTISEMENT

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

New Member
Joined
Mar 11, 2019
Messages
5
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,487
Messages
5,529,156
Members
409,851
Latest member
Ingar
Top