Hi @Michael Nollette ,
For your needs, you could refer to the following link:
https://stackoverflow.com/questions/10882784/ssrs-how-to-continue-data-to-next-column/10890383#10890383
Usually I think it is more convenient to use TSQL statements than SSRS.
declare @t table
(col1 int,col2 int)
insert into @t values
(1, 6),
(2, 7),
(3, 8),
(4, 9),
(5, 10)
select * from @t
;with cte as (
select col1 rn from @t
union
select col2 rn from @t)
select *
from cte a
left join cte b on a.rn = b.rn -1 and b.rn % 2 = 0
where a.rn % 2 =1
Output:
Hope this helps.
Best Regards,
Joy
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.