lines = 'Group Number 1 8 2 19 3 5 4 24 5 11 6 20 7 18 8 21 9 27 10 16' con = textConnection( lines ) DF = read.table( con, header=TRUE ) close(con) DF$Group = NULL