Can anyone please help me in writing a simple macro for the below scenario
Source Data
Column 1
UNAME1
UNAME2

Column 2
CUST1
CUST2
CUST3
CUST4

I wanted it like, on a click of button it should generate a new workbook with format as shown below.

Column 1 Column 2
UNAME1 CUST1
UNAME1 CUST2
UNAME1 CUST3
UNAME1 CUST4
UNAME2 CUST1
UNAME2 CUST2
UNAME2 CUST3
UNAME2 CUST4

-Anil