Remember Me?

#1
November 7th 08, 11:24 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Nov 2008 Posts: 1
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
etc...

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

Hope so!!

#2
November 7th 08, 11:53 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 3,572
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
etc...

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

Hope so!!

#3
November 8th 08, 03:35 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 2,344
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
etc...

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

Hope so!!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post CW Excel Discussion (Misc queries) 7 July 24th 08 07:15 PM egrave Excel Discussion (Misc queries) 1 July 6th 08 11:09 PM Jennifer B. Excel Discussion (Misc queries) 2 June 25th 08 03:47 PM Wanna Learn Excel Discussion (Misc queries) 4 November 8th 07 09:00 AM Rhythm Excel Worksheet Functions 1 November 10th 05 02:04 PM

All times are GMT +1. The time now is 02:12 AM.