Converting labels from Word to an Excel spreadsheet

  • Thread starter Thread starter Leah Stein
  • Start date Start date
L

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?
 
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
 
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 ...
 
Back
Top