I’m trying to automate the sets of data. So far I have this code that filters the data to another sheet but I cannot figure out how to transpose the data vertically. I’ve tried adding Transpose:=True but it isn’t doing anything.