How can I make cross from data,Please help me.

S

Saeid

Hi
How can I change ( or set ) data that are in a column in rows to columns in
one row.( such as cross )

Best Regards,
Saeid.
 
I

I.C.E.

If you have to join a few rows, then you may do:
Insert - Function - CONCATENATE.
ATTENTION: If you want to join the texts but to have something between you
must insert in the every text the relevant symbol
(i.e.=CONCATENATE("B6/";"C6/";"D6/")
 
S

Saeid

|
Hi,
Thanks for your help,
This function joins several data into one cell ,But I won't join data into
one cell, Rather, I want to change direction of data from rows to cells.

Best Regards,
Saeid.
 
Top