About Column wise Paste

[parbatidebnath]

input in two cell name and title using after formula =CONCATENATE(A1,B1)and drag total formula. after draging desired output display. Then how to get this row wise report to column wise. copy this report row wise and paste column wise.


thanks & regards

Parbati Debnath

 

[Faseeh]

parbatidebnath


I am not clear regarding your question. You meant to say that names and titles are present in Col A & Col B and you used formula =CONCATENATE(A1,B1) down to the end in some other column??

 

[parbatidebnath]

yes after geting total report row wise, how to copy this content and paste this content column wise.


exampl

row wise report

Michael Jackson

Brad Pitt

Arnold Schwarzenegger


column wise report

Michael Jackson Brad Pitt Arnold Schwarzenegger


thanks & regards

Parbati Debnath

 

[bobhc]

Good day parbatidebnath


Use the transpose method of pasting, copy your column of data choose you row paste cell and pick the transpose paste opton

 

[parbatidebnath]

THANKS A LOT.

 

[bobhc]

"THANKS A LOT." for nothing or "THANKS A LOT" for helping??