A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Copying rows of data into new worksheet but placing data into colu



 
 
Thread Tools Display Modes
  #1  
Old June 6th, 2010, 04:01 AM posted to microsoft.public.excel.misc
Thalarctos
external usenet poster
 
Posts: 4
Default Copying rows of data into new worksheet but placing data into colu

I have a spreadsheet which contains 3375 records (Excel 2007). My quandry is
the following:

I need to reformat the rows into columns for each Dealer (starting a new row
for the next Dealer).

CURRENT SPREADSHEET:
DEALER LOCATION VOLUME AMOUNT
123 Anytown, USA 155 $24,100
123 Hometown USA 145 $25,000
123 Thistown USA 455 $56,000
123 Our town USA 687 $68,000
123 Their Town USA 767 $989,000
245 Anytown, USA 155 $24,100
245 Hometown USA 145 $25,000
245 Thistown USA 455 $56,000
245 Our town USA 687 $68,000
245 Their Town USA 767 $989,000
818 Anytown, USA 155 $24,100
818 Hometown USA 145 $25,000
818 Thistown USA 455 $56,000
818 Our town USA 687 $68,000
818 Their Town USA 767 $989,000

Desired results:
123 Anytown, USA 155 $24,100 123 Hometown USA 145 $25,000 123
Thistown USA 455 $56,000 123 Our town USA 687 $68,000 123 Their Town
USA 767 $989,000

NEXT ROW
245 Anytown, USA 245 $24,100 123 Hometown USA 245 $25,000 245
Thistown USA 455 $56,000 245 Our town USA 687 $68,000 245 Their Town
USA 767 $989,000
ETC.

Each dealer has 5 rows.

This data will then be copied into a larger spreadsheet which is already
formatted properly.

Manually copying this is not feasible as I have two spreadsheet that need to
be formatted as such. I am not versed in Macros so need any solutions in a
detailed manner. Thanks for any insight.




  #2  
Old June 6th, 2010, 04:38 PM posted to microsoft.public.excel.misc
Herbert Seidenberg
external usenet poster
 
Posts: 1,113
Default Copying rows of data into new worksheet but placing data intocolu

Excel 2007 Tables
Transpose rows to columns.
Variable # of reps allowed.
No code.
http://c0718892.cdn.cloudfiles.racks.../06_06_10.xlsx

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:55 AM.


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