Populate data in Col. as per previous Col.

Question

Hi,

I have a data set in excel in merged cells in column. However, when I input the data, the merged part becomes null. Thus I want to populate the data in null cells as the previous cells.

If It was in row, I could have done it with multi row formula tool. However, the data is in col, so unable to do it. For the reference, I have attached a sample data where I want to work. And, in output file, I want this kind of result.

Please help me!

Sample.xlsx

Output.xlsx

SoccerTil · Accepted Answer

Since Multi-Row seems your best choice, I'd Transpose the columns to rows and then Cross Tab them back together again.

saveeshkumar · Accepted Answer

Hi @Rahul_Analyst ,

Hope this help you.

Thanks

atcodedog05 · Accepted Answer

Hi @Rahul_Analyst

Here is how you can do it. I am using spaces in name so that it looks alike.

Workflow:

Hope this helps : )