Excel Question

[Cc_1]

Hi 

  Please, could you give my work a try. Please, find attached the excel workbook. Am trying to attain the highlighted Yellow Portion of the Workbook from the left part which is not highlighted yellow. I would appreciate whatever input you can provide. Thanks

[mceleavey]

Hi @Cc_1

There you go. Obviously you can input the blank columns if you like, simply by creating them in the formula tool.

Let me know if this is what you want. 

M.

[Cc_1]

Please, can you send a send screenshot of it. I am unable to open the workbook. Seems like my alteryx is an old version.

[mceleavey · Accepted solution]

Hi @Cc_1,

No problem:

[Cc_1]

Thanks for the response. Is it okay if I ask you the data view after the multi-row formula. I would like to see how if came out after the multi-row formula. Thanks

[mceleavey]

Hi @Cc_1,

The multi-row formula simply creates the country against each record, so you have the column before:

and after:

Hope this helps.

M.

[Cc_1]

Mine is not coming out that way. I might have missed something in the multi-row formula. Please, can you send only the screen shot of the multi-row formula. Thanks very much

[Cc_1]

Thanks very much. I got. I had checked on a box which was affecting it. Thanks

[mceleavey]

The actual formula is as follows:

if isempty([Country]) then [Row-1:Country] else [Country] endif

You need to calibrate the tool like this:

M.

[mceleavey · Accepted solution]

Hi @Cc_1,

Glad I could help.

Could You mark this as solved to help others on here?

Cheers,

M.