reformat to get more hierarchical view
 

hi,

I'd like to show something like:
valA,val10,val11,val21
valA,val10,val11,val22
valA,val10,val12,val58
valA,val10,val13,val59
valB,val90,val91,val92

as:

valA
, val10
,val11
,val21
,val22
,val12
,val58
,val13
,val59
valB
,val90
,val91
,val92

Is there any easy way to achive it?

thanks
chris

reformat to get more hierarchical view
 

Alternative suggestion.

Select A2:D5
menu FormatConditional Formatting
Change Condition1 to Formula Is
Select FormatFont
Change Color to white
exit

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ciapecki" wrote in message
ups.com...
hi,

I'd like to show something like:
valA,val10,val11,val21
valA,val10,val11,val22
valA,val10,val12,val58
valA,val10,val13,val59
valB,val90,val91,val92

as:

valA
, val10
,val11
,val21
,val22
,val12
,val58
,val13
,val59
valB
,val90
,val91
,val92

Is there any easy way to achive it?

thanks
chris

reformat to get more hierarchical view
 

On 13 Aug., 14:09, "Bob Phillips" wrote:
Alternative suggestion.

Select A2:D5
menu FormatConditional Formatting
Change Condition1 to Formula Is
Select FormatFont
Change Color to white
exit


Hi Bob,

I tried it but it did not do what I wanted.
Notice that from 5rows of data I want to get 13rows of data, this
conditional formatting formats only the cells, does not add, move etc
the cells with values

chris

reformat to get more hierarchical view
 

No it doesn't, that is why I called it an alternative. It does pick out the
data though IMO.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ciapecki" wrote in message
ups.com...
On 13 Aug., 14:09, "Bob Phillips" wrote:
Alternative suggestion.

Select A2:D5
menu FormatConditional Formatting
Change Condition1 to Formula Is
Select FormatFont
Change Color to white
exit


Hi Bob,

I tried it but it did not do what I wanted.
Notice that from 5rows of data I want to get 13rows of data, this
conditional formatting formats only the cells, does not add, move etc
the cells with values

chris