Forum Discussion
collapse columns together
i want to merge columns together i have500 rows with 6 columns, if column 1,2,3 have data then columns 4,5,6 are null. If Columns 4,5,6 have data, then columns 1,2,3 are null how can i colla...
thanks, i ended up doing a if col is not null then col, else if col1 is not null col1 else if col2 is not null col2
thanks, i ended up doing a if col is not null then col, else if col1 is not null col1 else if col2 is not null col2