Columns into rows from excel to word

[sivapc]

Hello helpers,

I'm trying to convert a column of information into row to word via excel. Example as below

in Excel

Name1	DOB1	Address1	Title1
Name2	DOB2	Address2	Title2

in Word in should look like

Name1,
DOB1,
Address1,
Title1

Name2,
DOB2,
Address2,
Title2


I tried transpose function in excel itself, but it turned out hideous. Any help would be appreciated

[Sadath31]

Hi

try this =TEXTJOIN(CHAR(10),TRUE,A3:D3) where A3:D3 is your data

this will fit the 4 cells text into one cell (dont forget to format the cell of 'wrap text' )
or if you want comma at the end use use this CSE formula =TEXTJOIN(CHAR(10),TRUE,A3:D3&",")

then copy the result & paste in word, is this useful ?

[Glenn Kennedy]

An Excel sheet is always preferable to in-thread layouts.

Please amend your profile to show the Excel version you are using.

Maybe this, copied down:

=TEXT(INDEX($A$2:$E$4,INT((ROWS($1:1)-1)/5)+1,MOD((ROWS($1:1)-1),5)+1)&"","dd/mm/yyyy")