create databasefrom a text list

[beppe]

I have a list in two columns which is like this:

Name; John
Surname: Doe
City: Venice
State: Italy
Tel: 999-999-999
Fax: 999-999-999
email: (e-mail address removed)
Name: Bart
Surname: Simpson
(and so on)


The first column is the "label" of the field and the second column is
the value of the fiield itself.

Since this list had been written is the way above mentioned, I am
wondering if there is a way to create a database out of it or to extract
or manipulate the data

For example I would have compsed the excel file like this
Name - Surname - City - etc...
Bart - Simpson - etc...

I hope someone can come up with a good answer, otherwise I''ll have to
copy & paste for one week!

Thanks in advance

 

[Bob Greenblatt]

I have a list in two columns which is like this:

Name; John
Surname: Doe
City: Venice
State: Italy
Tel: 999-999-999
Fax: 999-999-999
email: (e-mail address removed)
Name: Bart
Surname: Simpson
(and so on)


The first column is the "label" of the field and the second column is
the value of the fiield itself.

Since this list had been written is the way above mentioned, I am
wondering if there is a way to create a database out of it or to extract
or manipulate the data

For example I would have compsed the excel file like this
Name - Surname - City - etc...
Bart - Simpson - etc...

I hope someone can come up with a good answer, otherwise I''ll have to
copy & paste for one week!

Thanks in advance

What version of Excel? A VBA macro can do this pretty easily, but that won't
work in Excel 2008.

 

[JE McGimpsey]

I have a list in two columns which is like this:

Name; John
Surname: Doe
City: Venice
State: Italy
Tel: 999-999-999
Fax: 999-999-999
email: (e-mail address removed)
Name: Bart
Surname: Simpson
(and so on)


The first column is the "label" of the field and the second column is
the value of the fiield itself.

Since this list had been written is the way above mentioned, I am
wondering if there is a way to create a database out of it or to extract
or manipulate the data

For example I would have compsed the excel file like this
Name - Surname - City - etc...
Bart - Simpson - etc...

I hope someone can come up with a good answer, otherwise I''ll have to
copy & paste for one week!

If all records have the same fields, one way:

Create a second sheet,

A1: Name
B1: Surname
C1: City
etc.

A2:
=TRIM(MID(INDEX(Sheet1!$A:$A,(ROW()-2)*7+COLUMN()),FIND(":",INDEX(Sheet1!
$A:$A,(ROW()-2)*7+COLUMN()))+1,255))

Copy A2 across to G2. Copy A2:G2 down as far as required.

After you've done this, copy the cells in Sheet2, then choose Edit/Paste
Special, selecting the Values radio button.

 

[beppe]

What version of Excel? A VBA macro can do this pretty easily, but that won't
work in Excel 2008.

Oh gosh! It is 2008!

 

[beppe]

If all records have the same fields, one way:

Create a second sheet,

A1: Name
B1: Surname
C1: City
etc.

A2:
=TRIM(MID(INDEX(Sheet1!$A:$A,(ROW()-2)*7+COLUMN()),FIND(":",INDEX(Sheet1!
$A:$A,(ROW()-2)*7+COLUMN()))+1,255))

Copy A2 across to G2. Copy A2:G2 down as far as required.

After you've done this, copy the cells in Sheet2, then choose Edit/Paste
Special, selecting the Values radio button.

What a wonderful expression!!!
Thank you, thank you, thank you!!!
I knew it was possible!