I have data that looks like this...
1 A
1
1
1
2 B
2
2
2
3
3
3
4 C
4
4
It continues for 38,000 rows, and I need to auto fill the blank cells in column B with the initial value in column B associated with the unique values in column A, if one exists, and insert "N/A" if there is no value associated with the unique number in Column A. The result would look like this...
1 A
1 A
1 A
1 A
2 B
2 B
2 B
2 B
3 N/A
3 N/A
3 N/A
4 C
4 C
4 C
Is there any way to do this in excel? If not, any guidance with other programs would be helpful as well. Original data is in .CSV, but is not tidy. Excel sheet is tidy, but incomplete as displayed above.