Split a coloumn into different coloumns

[SZ]

I have one column with data in it. I have an sql query and data underneath then another sql query and the output underneath etc.

I need to split the data from one sql query to another. 

Is there a way to do this?

[SZ]

@EstherB47 Thank you worked perfectly :) much appreciated.