Quote Originally Posted by grose456 View Post
hi Paul.
i need the duplicate values to be gone, only the unique value to remain.
I thought they were

Can you provide an example?

In post #8 with the macro and the attachment, 'Original' is your data, 'Input' is a copy I made of 'Original' for testing

When I ran the macro on 'Input' it appeared to remove the duplicates on a column-by-column basis

Capture.JPG

'Output' is the transpose you asked for using 'input' as an input