Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 8th 08, 12:24 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 1
Default Moving data from row to columns

I am trying to work with a dbase of names/addresses. The dbase is arranged
in a column with name, address, zip running vertically. I want to move the
info to run horizontally each column reading: name, address, state, zip,
etc...

Is there an easy way to build a formula that will move the data as described
above?

Hope so!!

  #2   Report Post  
Old November 8th 08, 12:53 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,572
Default Moving data from row to columns

Are there *exactly* the same number of fields for each name?

You didn't mention city ... is city combined with the state in the same
cell?

In other words, does each and every entry take up the same, exact number of
rows?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"gauche8715" wrote in message
...
I am trying to work with a dbase of names/addresses. The dbase is arranged
in a column with name, address, zip running vertically. I want to move
the
info to run horizontally each column reading: name, address, state, zip,
etc...

Is there an easy way to build a formula that will move the data as
described
above?

Hope so!!



  #3   Report Post  
Old November 8th 08, 04:35 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default Moving data from row to columns

Hi,

Lets assume your data runs from A1:A1000 and there are 6 items of info for
each person - First Name, Last Name, Street, City, State, Zip. Enter the
following formula in D1 and copy it to the right to column G, and down as far
as necessary.

=INDEX(A$1:A$1000,6*(ROW(A1)-1)+COLUMN(A1),1)

if there are only 5 entries for each person just change the 6 to 5 in the
above formula.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"gauche8715" wrote:

I am trying to work with a dbase of names/addresses. The dbase is arranged
in a column with name, address, zip running vertically. I want to move the
info to run horizontally each column reading: name, address, state, zip,
etc...

Is there an easy way to build a formula that will move the data as described
above?

Hope so!!



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
Moving data between columns CW Excel Discussion (Misc queries) 7 July 24th 08 07:15 PM
Moving Columns egrave Excel Discussion (Misc queries) 1 July 6th 08 11:09 PM
moving duplicate data in rows to columns with same name Jennifer B. Excel Discussion (Misc queries) 2 June 25th 08 03:47 PM
Moving Columns in a Pivot Wanna Learn Excel Discussion (Misc queries) 4 November 8th 07 10:00 AM
IF statements and moving data to different columns Rhythm Excel Worksheet Functions 1 November 10th 05 03:04 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017