Help with ICC

Hi, and sorry about my bad english!

So, I have a problem with my data: I have a dataset with multiple variables, that have been tested twice. In order to investigate repeatability I need to get ICC values (test-retest situation). However, there are no own variables for tests and retests; instead, I have 1500 subjects and 3000 rows, because information about test/retest is too one variable (1 or 2) and every subject has been tested twice. Subject ID is also one variable, and naturally every ID occurs twice in the data and so on. What would be easiest way to perform intraclass correlation coefficient analysis in such case? I have tried to somehow rotate the data in excel (to have 1500 rows and twice as many variables than now) but there must be some easier way?