Table iS like this...
create table DailyIncome(VendorId nvarchar(10), IncomeDay nvarchar(10), IncomeAmount int)
insert into DailyIncome values (SPIKE, FRI, 100)
insert into DailyIncome values (SPIKE, MON, 300)
insert into DailyIncome values (FREDS, SUN, 400)
insert into DailyIncome values (SPIKE, WED, 500)
insert into DailyIncome values (SPIKE, TUE, 200)
insert into DailyIncome values (JOHNS, WED, 900)
insert into DailyIncome values (SPIKE, FRI, 100)
insert into DailyIncome values (JOHNS, MON, 300)
insert into DailyIncome values (SPIKE, SUN, 400)
insert into DailyIncome values (JOHNS, FRI, 300)
insert into DailyIncome values (FREDS, TUE, 500)
insert into DailyIncome values (FREDS, TUE, 200)
insert into DailyIncome values (SPIKE, MON, 900)
insert into DailyIncome values (FREDS, FRI, 900)
insert into DailyIncome values (FREDS, MON, 500)
insert into DailyIncome values (JOHNS, SUN, 600)
insert into DailyIncome values (SPIKE, FRI, 300)
insert into DailyIncome values (SPIKE, WED, 500)
insert into DailyIncome values (SPIKE, FRI, 300)
then i want columns to rows and rows to colums...