Right, i have a long long long list of data. The first column is a name column, and entries for particiular names appear multiple times. The idea of it is that I want to sort the data so that the current data in the 2nd/3rd/so on entries of the name will get put in the same row as the first instance of the name.
Following? I could do this manually but it'll take forever. Must be some sort of query to select certain cells from all row with the name "Ryan Atkins" for example, say if i want the E-H cells of that row. Then i'd need these to copy into one row.
Anyone got any ideas?
Following? I could do this manually but it'll take forever. Must be some sort of query to select certain cells from all row with the name "Ryan Atkins" for example, say if i want the E-H cells of that row. Then i'd need these to copy into one row.
Anyone got any ideas?