View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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