Hello Community, First time poster here, i want to create a matrix out of a sheet of values.Lets say my sheets looks like this:Name: Rohdaten123456378 i want to create on a new sheet the following:111000000001110000100011 is there an easy way to get this without vb?I got it for the first row: =WENN(SPALTE()=Rohdaten!B2;1;0)

AnonUser You can try this formula =IFERROR(--(MATCH(COLUMN(),1:1,0)>0),0)

Forum Discussion

Copper Contributor

Jun 04, 2020

Hello Community,

First time poster here,

i want to create a matrix out of a sheet of values.

Lets say my sheets looks like this:

Name: Rohdaten

i want to create on a new sheet the following:

is there an easy way to get this without vb?
I got it for the first row: =WENN(SPALTE()=Rohdaten!B2;1;0)