Help with prompt exporting to excel and layout adjustment

[cognos05]

Hi ,

I am having a table with 3 columns and 1 row .

Fist column having a text item as select the country .

Second have an value prompt and third column having a layout calculation to show prompt value in excel and pdf .

Since value prompt values doesnt not show in excel it creates and empty column in excel  and my third value layout  goes to right end .


so if we place any control below this we are having merging issues because of the above issue .

Is there a way to not have this empty column in excel . have anyone faced similar issue .