Hello, I want a macro that will look at columns F through K and:
If a cell in those columns contains a value, then insert a row after
Transpose the value to column E
(Optional) auto-fill columns A, B, C, and D with the preceeding value
Note that if a cell in columns F-K has a value, then the...