Sorry dwain .. data

INSERT INTO [Table]

SELECT 1234, 1, 'True', 'False', 'False', 2, 'False', 'False', 'False', 3, 'True', 'True', 'True', 4, 'False', 'False', 'False'

One other complication, looking to filter and only show column1,2,3,4 When 2 or 3, or 4 = 'True'

Result should be something like

recordid column1, column2, column3, column4

1234 1 true f f

1234 3 true true true

Looking at your cross apply now. Thanks for the link hadn't seen that.