There is an entire Data section on the Excel ribbon, of which the left hand side is given over to importing and formatting data. The underlying functions have been available for decades.
The problem is largely around the complete failure of universities and other institutions to take software training seriously. Since most of these people can't even book a meeting properly, forget about them trying to manipulate data.
Biting the hand that feeds IT
