For both analyses you need only two columns and not more. T-test tests the difference in means between two samples, so first column is allocated to group number (1 and 2, or A and B). The second belongs to the variable that you measured.
For Pearson correlation first column filled with one variable and the second with another.