rrocker1405
Member
Hi,
In the attached spreadsheet I'm trying to fill in the blank cells for Columns A thru F automatically using Special > blank cells. However, it does for the entire column which is not what I want. I would like to fill in only when there is a value like shown in the desired output.
Column A - F is the data table where as Column H - M is the desired output. Basically all I'm trying to get is a flat view of the tree. Could this be done?
http://1drv.ms/1CLVuVF
Thanks in advance.
regards...A!
In the attached spreadsheet I'm trying to fill in the blank cells for Columns A thru F automatically using Special > blank cells. However, it does for the entire column which is not what I want. I would like to fill in only when there is a value like shown in the desired output.
Column A - F is the data table where as Column H - M is the desired output. Basically all I'm trying to get is a flat view of the tree. Could this be done?
http://1drv.ms/1CLVuVF
Thanks in advance.
regards...A!