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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top