Populate data in Col. as per previous Col.

[Rahul_Analyst]

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!

[SoccerTil · Accepted solution]

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

[saveeshkumar · Accepted solution]

Hi @Rahul_Analyst ,

Hope this help you.

Thanks

[atcodedog05 · Accepted solution]

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 : )

[saveeshkumar]

Hi ,

Please find the update formula to remove numbers form the header.

if contains([Name],'F') then
[Row-1:NewC]+ " "
else
[Name]
endif

Thanks.

[Rahul_Analyst]

@saveeshkumar , @atcodedog05 , @SoccerTil 

Thanks for your responses, all the responses gave me an idea to solve it. 

[atcodedog05]

Happy to help : ) @Rahul_Analyst 

Cheers and have a nice day!