View Single Post
 
Old 09-15-2017, 02:04 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

I think that with Excel 2013 you will have to use some VBA code as shown at this link (at the bottom):

https://answers.microsoft.com/en-us/...158d67d?auth=1

and then use a formula like:

=TEXTJOIN(" ",TRUE,OFFSET($A$1,(ROW(1:1)-1)*3,,3))

(with your data as from A1 and downwards).

In office 365 Excel there is a built-in function TEXTJOIN so here you don't need the VBA code.
Reply With Quote