Transpose a vertical list horizontally with an added space in excel and googlesheets NoVBA

[smart_beta]

Hi Excel People!

I have a list of stocks saved vertically in google sheets. I'd like to transpose them horizontally automatically with and added space in between each stock ticker. what formula can I write to accomplish this? I've attached a sample for clarity.

Thank you kindly.

[FDibbins]

You say you dont want VBA, yet this is a VBA enabled file?

[smart_beta]

The reason I don't want VBA is because I want the formula to work in google sheets.

Thank you.

[JohnTopley]

TRy

=IF(MOD((COLUMNS($A:A)-1),2)=0,INDEX($B$5:$B$12,INT((COLUMNS($A:A)-1)/2)+1),"")

[wk9128]

Cell E4 formula , Drag right

[bebo021999]

try:

Please Login or Register  to view this content.

[smart_beta]

Works great! Thank you for helping and teaching me new tricks.

[smart_beta]

This works too! Thank you so much!

[wk9128]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'.

[smart_beta]

Hey! How to I mark it as solved? Do I just write it in the Description on my end or is there a button I'm not seeing?

[FDibbins]

Use the "Thread Tools" towards the top (right) of the page. (I will do it for you - this time)