I have a spreadsheet that has mulitple rows and columns. Column A has a unique identifier. Many of the rows have blank cells in columns from B to CA.
I'm looking to write a function goes through each column, identifies the blanks, nad pastes them in another table.
Ultimately, what I want as an output is a table that shows for each unique identifier, the columns that a blank:
[TABLE="width: 500"]
ID
Column Name
A
column A header
A
column E header
B
column F header
B
column J header
B
column K header
B
column M header
[/TABLE]
Anyone got any suggestions?
Hope this makes sense!