Hi everyone, this is probably simple but I just dont know which way to attack the problem.
I have 2 columns:
A 1
B 2
C 3
D 4
I need them to be 1 row:
A 1 B 2 C 3 D 4
Thanks in advance.
Hi everyone, this is probably simple but I just dont know which way to attack the problem.
I have 2 columns:
A 1
B 2
C 3
D 4
I need them to be 1 row:
A 1 B 2 C 3 D 4
Thanks in advance.
Hi!
Assume your data is in the range A1:B4
Enter this formula in the first cell where you want the transposed data to
appear:
=OFFSET($A$1,INT((COLUMNS($A:A)-1)/2),MOD(COLUMNS($A:A)-1,2))
Copy across as needed.
Biff
"Fotop" <[email protected]> wrote in
message news:[email protected]...
>
> Hi everyone, this is probably simple but I just dont know which way to
> attack the problem.
>
> I have 2 columns:
>
> A 1
> B 2
> C 3
> D 4
>
> I need them to be 1 row:
>
> A 1 B 2 C 3 D 4
>
> Thanks in advance.
>
>
> --
> Fotop
> ------------------------------------------------------------------------
> Fotop's Profile:
> http://www.excelforum.com/member.php...o&userid=27880
> View this thread: http://www.excelforum.com/showthread...hreadid=473843
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks