Copy data from one sheet to another in excel vba

Press Cntrl-C to copy the entire range. Click in the new sheet you create. Right click call A1, and choose the Transpose option from Paste Options. Now you'll see your original spreadsheet, but with the header row swapped with the first column, and all of the data in the range organized to line up correctly. ................
................