hi,

i have this data
Column1
textstring that specifies if something is new
LOCATION NAME ADR POST TLF. DATE SEGMENT
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
textstring that specifies if something is new
LOCATION NAME ADR POST TLF. DATE SEGMENT
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME 11
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
textstring that specifies if something is shutting down
LOCATION NAME ADR POST TLF. DATE SEGMENT
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME
textstring that specifies if something is new
LOCATION NAME ADR POST TLF. DATE SEGMENT
locationdata name Street,nr 7845-cityname tlfnr YYYYYMMDD SEGMENTNAME

I would like to turn it into this

Location Name ADR POST TLF DATE SEGMENT status
xxxx xxxx xxx xxxx xxxx xxxxx xxxx new
xxxx xxxx xxx xxxx xxxx xxxxx xxxx closed

i'm lost.. help?