How to get the following output in excel sheet?

image

This is my input file
image

this is what i need as output table…

image

i done till this i have transpose the data to this but i am not getting how to count the data and print “1” in the desire cell

@NervousTuber

You can check below as a reference, where we are writing the result in desired column

Reference

Hope this may help you

Thanks

nope i dont get it…
can you give me an .xaml file for my following output?

Hi!

please can you tell me your input file contains 1’s and 0’s. but you wants to make it as 0?

please can you show me the desired output table?

Regards,
NaNi

This is my input:
image

this is my desired output:
image

Hi @NervousTuber,
I want to know, in the id column i saw a,b,c values only so my question is your excel contains only a,b,c values or more than that ??
Thanks

image
this is my actual input file

and i want the output like this:
image

Hi @NervousTuber

Please find the attached xaml file with input ,usecase as output excel
kindly mark it as solution
input.xlsx (8.3 KB)
test3.xaml (34.4 KB)
usecase.xlsx (7.2 KB)

Regards,
Robin

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.