Hey Everyone, I'm trying to create a macros to check raw data. I have a range called PtTxt, which is a pivot table, but text only is copied. I want a specific column copied as a row a couple columns away from the current location. how would i go about doing that in vba? the cells are merged, but i want them not merged.