Data Validation

[vijaylnyadav]

Consider the following data,

Roll Number	Performance
1	Good
2	Average
3	Bad
4	Average
5	Good
6	Good
7	Bad
8	Bad
9	Average
10	Average

Condition:

I want to group the data according to the performance

e.g.: All the good in one, bad in one and Average in one like the below result which i wanted

Performance	Roll No
Good	1 5 6
Average	2 4 9 10
Bad	3 7 8

Please suggest some workflow.

Thanks 

[Emil_Kos]

Hi @vijaylnyadav,

Do you need to have them in a merged cell? 

[vijaylnyadav]

@Emil_Kos  Yes I want to have in a merged cells

[Emil_Kos]

Hi @vijaylnyadav,

I am not sure if this is possible. At least I wasn't able to find an answer in the community.

At the same time, this topic states you cannot do that for the XLSX format. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Conditional-Merging-of-cells/td-p/3901...

Apologies that I couldn't help you more. 

[vijaylnyadav]

@Emil_Kos can you help me on the below problem:

I have a multiple output data(more than 10) and I want to save all the data in a single excel file.

I am using folder browse so that the user can select their desire output after that I am using action tool that will update the output with formula but i am facing an error and i.e. sometimes it is saying that access denied and sometimes it is saying that file is being used by different process.

Therefore I have used block until done but still I am facing the same error and I am unable to save my output to multiple tabs in single excel files.

Some solutions will be a great help.

i have attached a sample data and sample workflow for your reference.

I am stuck at this point so please help me out.

[Emil_Kos]

Hi @vijaylnyadav,

You forgot to add attachments.

Please create a new topic as it will make whole process easier. 

[Qiu · Accepted solution]

@vijaylnyadav 
Tried with embeding new line in the formula.

[vijaylnyadav]

Thanks @Qiu  for your help but till text to column tool all is fine but after that the data are missing means for only one type we are getting only one data and other data are lost

[Qiu · Accepted solution]

@vijaylnyadav 
The data is not lost. 

One step is required though, which is to increase the row height in opened output Excel file.

[vijaylnyadav]

thanks @Qiu  for this effort I got the desired output.

Pleae help me on another post of Mulitple Tabs.