---------------------------------------------------------------
--set up a table variable similar to your actual table
declare @t table (rid int, photo varchar(12), nm varchar(12))
insert @t 
select 1, 'photo1.jpg', 'john smith' union all
select 2, 'photo2.jpg', 'jane doe' union all
select 3, 'photo3.jpg', 'bob brown' union all
select 4, 'photo4.jpg', 'mary brown' union all
select 5, 'photo5.jpg', 'sue smith' union all
select 6, 'photo6.jpg', 'bob rogers'
---------------------------------------------------------------
--take a look at the raw data
select * from @t

--flatten every three rows into 1 row of 6 columns
select pic_col_1 = max(case when rid % 3 = 1 then photo end)
       ,name_col_1 = max(case when rid % 3 = 1 then nm end)
       ,pic_col_2 = max(case when rid % 3 = 2 then photo end)
       ,name_col_2 = max(case when rid % 3 = 2 then nm end)
       ,pic_col_3 = max(case when rid % 3 = 0 then photo end)
       ,name_col_3 = max(case when rid % 3 = 0 then nm end)
from   @t
group by (rid-1) / 3

output:
rid         photo        nm
----------- ------------ ------------
1           photo1.jpg   john smith
2           photo2.jpg   jane doe
3           photo3.jpg   bob brown
4           photo4.jpg   mary brown
5           photo5.jpg   sue smith
6           photo6.jpg   bob rogers


pic_col_1    name_col_1   pic_col_2    name_col_2   pic_col_3    name_col_3
------------ ------------ ------------ ------------ ------------ ------------
photo1.jpg   john smith   photo2.jpg   jane doe     photo3.jpg   bob brown
photo4.jpg   mary brown   photo5.jpg   sue smith    photo6.jpg   bob rogers