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

Closed
vivek - Oct 2, 2015 at 10:54 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Oct 5, 2015 at 11:54 AM
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

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Oct 5, 2015 at 11:54 AM
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
0