Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do i convert vertical data into horizontal data

I am not sure that this can be done but I am scanning a list of people,
address, city state and zip
I can get it into excel but haven't figured out how to get into a format
that will allow me to import it into a database.

The data looks like this in the spreadsheet.

Name first name other name
Company
Address (streee city st zip)
Phone
email
other info
even more info

I will have about 4000 names to deal with so some method of transposing all
of this would be a real help.

Even some suggestions as to software that will help would great.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default how do i convert vertical data into horizontal data

Is there a blank row between each record to help identify each block
of data? And if an item is missing, such as email address, will this
have a blank cell, or will the data be bunched up for each person?

Pete

On Feb 27, 4:38*pm, Rod Dakan <Rod
wrote:
I am not sure that this can be done but I am scanning a list of people,
address, city state and zip
I can get it into excel but haven't figured out how to get into a format
that will allow me to import it into a database.

The data looks like this in the spreadsheet.

Name first name other name
Company
Address (streee city st zip)
Phone
email
other info
even more info

I will have about 4000 names to deal with so some method of transposing all
of this would be a real help.

Even some suggestions as to software that will help would great.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default how do i convert vertical data into horizontal data

There is a blank row between records, but if data is missing a blank cell is
not there. Dang that will make it harder.

Rod

"Pete_UK" wrote:

Is there a blank row between each record to help identify each block
of data? And if an item is missing, such as email address, will this
have a blank cell, or will the data be bunched up for each person?

Pete

On Feb 27, 4:38 pm, Rod Dakan <Rod
wrote:
I am not sure that this can be done but I am scanning a list of people,
address, city state and zip
I can get it into excel but haven't figured out how to get into a format
that will allow me to import it into a database.

The data looks like this in the spreadsheet.

Name first name other name
Company
Address (streee city st zip)
Phone
email
other info
even more info

I will have about 4000 names to deal with so some method of transposing all
of this would be a real help.

Even some suggestions as to software that will help would great.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default how do i convert vertical data into horizontal data

Yes, it will be harder, but if there is a guaranteed blank row between
each record (and no other blank rows) then at least it is possible to
gather the data together for each record on one row. You might then
need to move some of the data horizontally to make room for missing
items of data, like an email address, but I think you can only do this
manually. You will need a macro for the first part.

Pete

On Feb 27, 5:04*pm, Rod Dakan
wrote:
There is a blank row between records, but if data is missing a blank cell is
not there. *Dang that will make it harder.

Rod



"Pete_UK" wrote:
Is there a blank row between each record to help identify each block
of data? And if an item is missing, such as email address, will this
have a blank cell, or will the data be bunched up for each person?


Pete


On Feb 27, 4:38 pm, Rod Dakan <Rod
wrote:
I am not sure that this can be done but I am scanning a list of people,
address, city state and zip
I can get it into excel but haven't figured out how to get into a format
that will allow me to import it into a database.


The data looks like this in the spreadsheet.


Name first name other name
Company
Address (streee city st zip)
Phone
email
other info
even more info


I will have about 4000 names to deal with so some method of transposing all
of this would be a real help.


Even some suggestions as to software that will help would great.- Hide quoted text -


- Show quoted text -


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default how do i convert vertical data into horizontal data


Well that is a beginning can you point me to someone who can write the macro?

Thanks

Rod
"Pete_UK" wrote:

Yes, it will be harder, but if there is a guaranteed blank row between
each record (and no other blank rows) then at least it is possible to
gather the data together for each record on one row. You might then
need to move some of the data horizontally to make room for missing
items of data, like an email address, but I think you can only do this
manually. You will need a macro for the first part.

Pete

On Feb 27, 5:04 pm, Rod Dakan
wrote:
There is a blank row between records, but if data is missing a blank cell is
not there. Dang that will make it harder.

Rod



"Pete_UK" wrote:
Is there a blank row between each record to help identify each block
of data? And if an item is missing, such as email address, will this
have a blank cell, or will the data be bunched up for each person?


Pete


On Feb 27, 4:38 pm, Rod Dakan <Rod
wrote:
I am not sure that this can be done but I am scanning a list of people,
address, city state and zip
I can get it into excel but haven't figured out how to get into a format
that will allow me to import it into a database.


The data looks like this in the spreadsheet.


Name first name other name
Company
Address (streee city st zip)
Phone
email
other info
even more info


I will have about 4000 names to deal with so some method of transposing all
of this would be a real help.


Even some suggestions as to software that will help would great.- Hide quoted text -


- Show quoted text -





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default how do i convert vertical data into horizontal data

Well, you might get someone posting a macro here if they read the thread, or
you might like to begin a new post in the .programming group.

Hope this helps.

Pete

"Rod Dakan" wrote in message
...

Well that is a beginning can you point me to someone who can write the
macro?

Thanks

Rod
"Pete_UK" wrote:

Yes, it will be harder, but if there is a guaranteed blank row between
each record (and no other blank rows) then at least it is possible to
gather the data together for each record on one row. You might then
need to move some of the data horizontally to make room for missing
items of data, like an email address, but I think you can only do this
manually. You will need a macro for the first part.

Pete

On Feb 27, 5:04 pm, Rod Dakan
wrote:
There is a blank row between records, but if data is missing a blank
cell is
not there. Dang that will make it harder.

Rod



"Pete_UK" wrote:
Is there a blank row between each record to help identify each block
of data? And if an item is missing, such as email address, will this
have a blank cell, or will the data be bunched up for each person?

Pete

On Feb 27, 4:38 pm, Rod Dakan <Rod
wrote:
I am not sure that this can be done but I am scanning a list of
people,
address, city state and zip
I can get it into excel but haven't figured out how to get into a
format
that will allow me to import it into a database.

The data looks like this in the spreadsheet.

Name first name other name
Company
Address (streee city st zip)
Phone
email
other info
even more info

I will have about 4000 names to deal with so some method of
transposing all
of this would be a real help.

Even some suggestions as to software that will help would great.-
Hide quoted text -

- Show quoted text -





  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default how do i convert vertical data into horizontal data

Give this macro a shot on a copy of your sheet.

May be close to your needs.

Sub ColtoRows()
Dim rng As Range
Dim I As Long
Dim J As Long
Set rng = Cells(Rows.Count, 1).End(xlUp)
J = 1
On Error Resume Next
nocols = InputBox("Enter Number of Columns Desired")
For I = 1 To rng.Row Step nocols
Cells(J, "A").Resize(1, nocols).Value = _
Application.Transpose(Cells(I, "A").Resize(nocols, 1))
J = J + 1
Next
Range(Cells(J, "A"), Cells(rng.Row, "A")).ClearContents
Exit Sub
End Sub



Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 08:38:03 -0800, Rod Dakan <Rod
wrote:

I am not sure that this can be done but I am scanning a list of people,
address, city state and zip
I can get it into excel but haven't figured out how to get into a format
that will allow me to import it into a database.

The data looks like this in the spreadsheet.

Name first name other name
Company
Address (streee city st zip)
Phone
email
other info
even more info

I will have about 4000 names to deal with so some method of transposing all
of this would be a real help.

Even some suggestions as to software that will help would great.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Turn vertical data to horizontal data automaticaly Leandro Sesarego Excel Worksheet Functions 7 August 2nd 08 04:31 AM
Need lookup of data both vertical and horizontal rmargh Excel Discussion (Misc queries) 2 November 21st 07 06:10 PM
transposing vertical data to horizontal with varying amount of data Ghosty Excel Discussion (Misc queries) 5 August 1st 06 05:20 AM
How to make Horizontal data go Vertical tx12345 Excel Worksheet Functions 10 December 24th 05 04:40 AM
tranfere vertical data to horizontal tabel dagfinn Excel Worksheet Functions 2 January 29th 05 07:19 PM


All times are GMT +1. The time now is 08:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"