LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Grouping/Transposing CSV File?

Hi All, I've got a CSV file with two fields, product code and group. I
can get it into Excel just fine, what I want to do is convert the
groups into columns. Like, I'd want the "GOLF" column to have those 4
product codes beneath it.



002-0001-GOTIPPER GOLF
002-0002-GOTIPMOT GOLF
002-QUIC-GOLFTIPS GOLF
003-QUIC-GOLFGAME GOLF
004-QUIC-CASINOGA BUSINESS
005-0001-HOMEMAIN BUSINESS
005-QUIC-HOMEMAIN BUSINESS
006-QUIC-ROADSAFE SAFETY
007-QUIC-INDUSAFE SAFETY
008-QUIC-OFFISAFE SAFETY
009-QUIC-INTERNET BUSINESS
010-QUIC-BORGIDEA BUSINESS

Can someone help me out? I'm quite new to Excel.


 
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
Transposing Nanapat Excel Discussion (Misc queries) 2 April 2nd 08 11:38 PM
Transposing Deena Excel Worksheet Functions 2 October 27th 06 05:13 PM
transposing question... cherrynich Excel Worksheet Functions 2 April 24th 06 03:49 PM
TRANSPOSING GARY Excel Discussion (Misc queries) 1 March 17th 06 11:09 AM
Transposing cells GARY Excel Discussion (Misc queries) 0 March 17th 06 12:03 AM


All times are GMT +1. The time now is 11:43 PM.

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

About Us

"It's about Microsoft Excel"