reformat to get more hierarchical view

[ciapecki]

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

 

[Bob Phillips]

Alternative suggestion.

Select A25
menu Format>Conditional Formatting
Change Condition1 to Formula Is
Select Format>Font
Change Color to white
exit

--
HTH

Bob

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

 

[ciapecki]

Alternative suggestion.

Select A25
menu Format>Conditional Formatting
Change Condition1 to Formula Is
Select Format>Font
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

 

[Bob Phillips]

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)