Hi,
I have a large excel file with thousands of columns.
I want to keep all column headers plus only those cells which contain specific text '2G'. Rest of the cells should be deleted so that I am only left with column header and required cells below.
Sample photos of 'Before' and 'After' scenario is attached.
'Before' scenario which shows the raw data where I have to keep only those cells having the text '2G'.
'After' scenario shows required data after cleaning done.
I have a large excel file with thousands of columns.
I want to keep all column headers plus only those cells which contain specific text '2G'. Rest of the cells should be deleted so that I am only left with column header and required cells below.
Sample photos of 'Before' and 'After' scenario is attached.
'Before' scenario which shows the raw data where I have to keep only those cells having the text '2G'.
'After' scenario shows required data after cleaning done.