I have data on sheet1: one row per item. I would like to copy and transpose certain columns but not all to sheet2.
lines with "not" in the B column need to be skipped. see the example.
hope you can help!
what I have
What I need
lines with "not" in the B column need to be skipped. see the example.
hope you can help!
what I have
What I need