problem with data format

hi

i am not a pro in using excel.i have a problem with my chart

 

i have a chart like this:

 

a   |   hello

 

b   |    hi

 

a   |   how are you?

 

b   |   not bad

 

.

.

.

 

and i want to change the format of this dialogue, like this:

 

a   |   b

 

hello|[empty]

 

[empty]|   hi

 

how are you?|[empty]

 

[empty]|not bad

By: armin

Leave a Reply

Your email address will not be published. Required fields are marked *