Double Column Return

Copper Contributor

Hello,

 

I have a spreadsheet with Part Numbers on one side and Warehouse numbers on the other. Its a two column sheet. I want to transpose the warehouses to become columns instead of rows and populate the cells that match with an "X". How can I do this?

 

1 Reply

@arifs1870 

=IF(E$3=$C4,"x","")

Maybe like in this example?

part warehouse.JPG