|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
May 1st, 2002, 08:50 PM
|
#1 |
|
New Member
Join Date: Apr 2002
Posts: 8
|
Hi Experts,
I got some problem. I have a spreadsheet in this format: A1 A2 A3 A4 1 A Pte Ltd SAM Siemens Intel 2 B Pte Ltd 3 C Pte Ltd Mot Hitachi AMD and the list goes on. There are some rows with A1 data but A2 onwards are blank. That means, Company with carrying no brand names (eg. B Pte Ltd). How do I reformat the list to be as below and omit those with no brand names : A1 A2 A3 A4 1 A Pte Ltd SAM 2 A Pte Ltd Siemens 3 A Pte Ltd Intel 4 C Pte Ltd Mot 5 C Pte Ltd Hitachi 6 C Pte Ltd AMD Thanks! |
|
|
|
May 1st, 2002, 08:54 PM
|
#2 |
|
Board Regular
Join Date: Mar 2002
Location: Sydney/Brisbane , Australia
Posts: 539
|
why dont you run an auto filter on column 2.
and then filter for "BLANK" and delete the lines it then shows? |
|
|
|
|
May 1st, 2002, 08:58 PM
|
#3 |
|
New Member
Join Date: Apr 2002
Posts: 8
|
Ok but I need to format the data to appear downwards also.
|
|
|
|
|
May 1st, 2002, 09:05 PM
|
#4 |
|
Board Regular
Join Date: Mar 2002
Location: Sydney/Brisbane , Australia
Posts: 539
|
so is a4 currently Sam Siemens Intel?
or is a4=sam,a5=Siemans,a6 = intel? |
|
|
|
|
May 1st, 2002, 09:12 PM
|
#5 |
|
New Member
Join Date: Apr 2002
Posts: 8
|
A1= A Pte Ltd ,A2= SAM, A3= Siemens, A4= Intel
to be : A1: A Pte Ltd A2: Sam B1: A Pte Ltd B2: Siemens C1: A Pte Ltd C2: Intel Sounds tedious. |
|
|
|
|
May 1st, 2002, 09:18 PM
|
#6 |
|
Board Regular
Join Date: Mar 2002
Location: Sydney/Brisbane , Australia
Posts: 539
|
EVERY1 FEEL FREE TO ASSIST
i am trying to work on a code to a: count the number of brands in a row b: copy the brands in the row c: insert that number of rows(=to number of brands) d: transpose the brands... e:goto next line |
|
|
|
|
May 1st, 2002, 09:21 PM
|
#7 |
|
New Member
Join Date: Apr 2002
Posts: 8
|
Number of brands is not fixed for any company. So company A can have 3 , while Company F could have only one. I can't say there is any max number of brands for each company. Range from 0 to x.
|
|
|
|
|
May 1st, 2002, 09:34 PM
|
#8 |
|
Board Regular
Join Date: Feb 2002
Location: Huntington Beach, CA USA
Posts: 327
|
Hi goofydisney,
I see your new to this board, hang in there even though a lot of people will jump in w/ the right intentions to help, it's easy to get very,very frustrated. I posted a simple formula question last nite and was told to "slow down" , "check my calcs" and they even were joking amongst each other on my thread even though they couldn't figure out the formula. Then along came the "master" of formulas Aladin, I hope he sees your post. Good Luck James |
|
|
|
|
May 1st, 2002, 10:05 PM
|
#9 |
|
New Member
Join Date: Apr 2002
Posts: 8
|
Hi James,
Thanks  You guys on this board are so helpful. I am from Singapore and yesterday was a holiday (MayDay) and I can't believe it you guys are helping out here. In Singapore, we say "Give that guy a Tiger Beer!" |
|
|
|
|
May 2nd, 2002, 06:55 PM
|
#10 |
|
New Member
Join Date: Apr 2002
Posts: 8
|
Hi Experts,
I hope you can help me on this one. Rdgs |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
