Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default to convert columns to rows having mulit independent group columns

i have a list to over 1000 contacts in column form. i would like to convert
these contact into row from. Microsoft lets you convert one group at a time.
If i highlight more than one group and paste special they come up side by
side on same line.

I would like each group to come up the right side of each contact
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default to convert columns to rows having mulit independent group columns

Quacy

There are ways to do what you want.

Copy and paste a sample of your layout.

How many rows per contact?

Any blanks in between?

Example of layout could like so................or other?

firstname
lastname
address
city
state
zip
<blank or not
firstname
lastname
address
city
state
zip


Gord Dibben MS Excel MVP

On Tue, 22 Aug 2006 12:59:01 -0700, Quacy
wrote:

i have a list to over 1000 contacts in column form. i would like to convert
these contact into row from. Microsoft lets you convert one group at a time.
If i highlight more than one group and paste special they come up side by
side on same line.

I would like each group to come up the right side of each contact


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
Convert rows to columns Geno Excel Worksheet Functions 0 July 6th 06 04:41 PM
Rows & Columns in Excel seadragon69 Excel Worksheet Functions 2 December 7th 05 06:54 PM
Repeating Rows and Columns on each page of print out BruceM Excel Discussion (Misc queries) 1 July 6th 05 12:28 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 02:46 PM
how do you group and ungroup rows or columns in new Excel? moocowcreamer Excel Worksheet Functions 2 November 17th 04 03:28 AM


All times are GMT +1. The time now is 12:16 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"