Excel

[Chris246]

Hello, I was wondering is there a shortcut that allows me to extract a certain number combination like (01011). Where each element is in a different column?

[#2]

Yes.. You can use Flash Fill... If you can upload a sample data, I can show you

[#3]

@Abiola1 Thank you for responding! This is an example of what i'm working on. I'm trying to extract the number combination (1 0 0 1 1 1 )