How to create a macro input that allows different columns of input

[Riyaz_Shaik]

I have a macro that should allow different input types, i.e., input may have different columns based upon the macro requirement.
How can I create a macro input that takes different columns each time and shows me in the drop-down?
Can you guys help me with this?
Thank you.

[OTrieger]

@Riyaz_Shaik 
What are you trying to achieve?

What will be the process that the user do?

[Riyaz_Shaik]

I was trying to create a macro that takes input and performs some actions, these actions  are performed on the selected columns based on the selections made through dropdown. So I need to get dynamic column names in the dropdown based on the input.

[Riyaz_Shaik]

I was trying to create a macro that takes input and performs some actions, these actions are performed on the selected columns based on the selections made through dropdown. So I need to get dynamic column names in the dropdown based on the input.

[OTrieger]

@Riyaz_Shaik 

Ok, in this case you might want to use chained apps, so the first one is pulling in the headers and then next one is taking the user to the User Interface to select the headers.

[Riyaz_Shaik]

Could you please explain in detail, I was trying to use the transpose tool but I couldn't able to achieve it.