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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Saeid - 11 Oct 2006 08:22 GMT

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.

Reply to this Message

I.C.E. - 11 Oct 2006 11:26 GMT

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/")

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

Reply to this Message

Saeid - 14 Oct 2006 12:36 GMT

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.

> If you have to join a few rows, then you may do:
> Insert - Function - CONCATENATE.
[quoted text clipped - 9 lines]
>> Best Regards,
>> Saeid.

Reply to this Message