Copy and Paste Fields in a different sequence

[Donal28]

Hi All

I have an output from a report and basically what I need to do is copy and paste some only of the fields from the output in a different sequence in a new sheet. The AS-IS Output is the report below and basically I just need to copy and paste 3 columns into a new sheet TO-BE Sheet in a different sequence and removing the dupes. In the AS-IS Output. The 3 columns in the AS-IS Output are Field Name( column E3), Field Attribute(column F3) and Field Purpose( column G3) and in the TO-BE Sheet these will be column A1,B1 and C1.

Any help on this would be very much appreciated

Regards
Donal