Hi all,
I would like copy the columns (data shown below [columns A:C]) to individual columns that are sorted by column A. For example, I would like deer 3 to have its associated water and road values listed next to it in separate columns (i.e., columns D:G), then deer 5 would be in columns H:J and so on down the list. Any help with a formula to accomplish this would be greatly appreciated, I've pulled my hair out enough and a pivot table doesn't seem to work.
Thanks!
deer water road
3 2250.7 108.8
3 2064 132.7
3 2030.4 132.8
3 1997.1 133
3 1961.6 163.1
5 1929.4 193.2
5 1899.5 223.3
5 1869.5 253.5
5 1844.8 283.6
5 1842 16.3
5 1822.2 104.4
7 1818.3 134.4
7 1801.7 104.6
7 1796.8 134.6
7 1773.1 45.2
7 1777.6 15.2
7 1743.5 135.6
Bookmarks