# Revision history [back]

### I want to redistribute the contents of one column into several

I have one column of data, of the form -

﻿Original Data

• [Icon0001]
Legacy=0
XCoord=14
YCoord=118
Name=Dell
Path=C:\Users\Dell
Monitor=0
[Icon0002]
Legacy=0
XCoord=14
YCoord=2
Name=Computer
Path=::{20D04FE0-3AEA-1069-A2D8-08002B30309D}
Monitor=0 etc.

I want to make it into 6 columns of the form

Icon Number Status  X=      Y=          Name            Path                        Monitor

[Icon0001] Legacy=0 XCoord=14 YCoord=118 Name=Dell Path=C:\Users\Dell Monitor=0;

[Icon0002] Legacy=0 XCoord=14 YCoord=2 Name=Computer Path=::{20D04FE0.. ..09D} Monitor=0

The original data is a long text file with each datum on one line, so L O Calc is importing it as a single column. Can anyone tell me how to fix this. I don't know whether I should be doing something different when I import the data, or if I can use some combination of formulae and filtering. Please help as I am fairly inexperienced with spreadsheets and this is giving me a headache!

Ciao, Kaelkitty.

### I want to redistribute the contents of one column into several

I have one column of data, of the form -

﻿Original Data

• [Icon0001]
Legacy=0
XCoord=14
YCoord=118
Name=Dell
Path=C:\Users\Dell
Monitor=0
[Icon0002]
Legacy=0
XCoord=14
YCoord=2
Name=Computer
Path=::{20D04FE0-3AEA-1069-A2D8-08002B30309D}
Monitor=0 etc.

I want to make it into 6 columns of the form

Icon Number Status  X=      Y=          Name            Path                        Monitor

[Icon0001] Legacy=0 XCoord=14 YCoord=118 Name=Dell Path=C:\Users\Dell Monitor=0;

[Icon0002] Legacy=0 XCoord=14 YCoord=2 Name=Computer Path=::{20D04FE0.. ..09D} Monitor=0

The original data is a long text file with each datum on one line, so L O Calc is importing it as a single column. Can anyone tell me how to fix this. I don't know whether I should be doing something different when I import the data, or if I can use some combination of formulae and filtering. Please help as I am fairly inexperienced with spreadsheets and this is giving me a headache!

Ciao, Kaelkitty.

I also tried copying and rewriting the formula {=T(OFFSET($A$1;ROW()*4+0;0))} that JOHNSUN mentioned in the comment on your answer but I can't seem to get the changes that would work on my sheet.