T
tans
Hi, I have columns that I tried to change the cell information t
another cell that have to be the blank for a row that contains directo
name in cell A and for the movie titles I have to have director name
instead of the titles.I totally lost, please help me, the data in cel
B sholuld have to be,
A
1 D:B.Jane
2 T:Back to the future
3 T:Aliens
4 T:X-files
5 D:Adam Mathew
6 T:Core
7 T:Titanic
B
1 (empty)
2 D:B.Jane
3 D:B.Jane
4 D:B.Jane
5 (empty)
6 D:Adam Mathew
7 D:Adam Mathew
Thanks in advance for any suggestions
another cell that have to be the blank for a row that contains directo
name in cell A and for the movie titles I have to have director name
instead of the titles.I totally lost, please help me, the data in cel
B sholuld have to be,
A
1 D:B.Jane
2 T:Back to the future
3 T:Aliens
4 T:X-files
5 D:Adam Mathew
6 T:Core
7 T:Titanic
B
1 (empty)
2 D:B.Jane
3 D:B.Jane
4 D:B.Jane
5 (empty)
6 D:Adam Mathew
7 D:Adam Mathew
Thanks in advance for any suggestions