Display a new entry in a column in a separate cell in excel

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

I am having a column;

A B

1 ab
2 abc
3 abcd
4 abcde
5 xyz
6

I want the next entry in 6 row of A to be entered into 1 row of B and likewise any next entry in column A should be displayed in 1 row of B.

Please help me with this!

Thanks.

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Vivek,

Well, if you want your value not in A6 but in B1, then select B1 before entering your data.

Don't see the issue here.

Best regards,
Trowa