Converting labels from Word to an Excel spreadsheet

[Leah Stein]

I have labels in Word that I want to use in Excel. If I just copy and paste
it I get 1 column with everything in it. I want it in separate columns. Is
it possible to do it automatically or do I have to do it manually?

 

[George Gee]

Paste the cells in an unused part of the Excel sheet.
Select the cells in the column you have just pasted.
Copy them, select the first destination cell,
right-click, checkmark in 'Transpose' click OK.

George Gee

 

[Max]

One way, assuming the col data is in regular groups of x lines per
group ..

Assuming source data in A1 down, with data in 10 lines per group viz:
1st group in A1:A10, 2nd group in A11:A20, 3rd group in A21:A30 etc

Put in B1:
=INDEX($A:$A,ROW(A1)*10-10+COLUMN(A1))
Copy B1 across by 10 cols to K1, then fill down until zeros appear,
signalling exhaustion of data. Cols B to K will return the required
results.

Adapt to suit the x lines per group, viz. change the "10" in the
formula to x, then copy across by x cols, fill down ...