hello,
i have a spread sheet with 8 coulmns, 4 represent different benefits, and 4 represent the cost of said benefits. its set up so that each column alternates between a benefit and cost.
the problem that i have is that there is no logic as to what benefit is in what column, so medical could be in column A for someone and column E for someone else.
is there any way to sort the list so that medical is in column A with its coresponding cost in column B, Dental in column C with its cost in D and so on.
thanks,
i have a spread sheet with 8 coulmns, 4 represent different benefits, and 4 represent the cost of said benefits. its set up so that each column alternates between a benefit and cost.
the problem that i have is that there is no logic as to what benefit is in what column, so medical could be in column A for someone and column E for someone else.
is there any way to sort the list so that medical is in column A with its coresponding cost in column B, Dental in column C with its cost in D and so on.
thanks,