Hi All,
Hope everyone is well & Safe !!
My requirement is like:- I have an excel sheet with a column name "PNR" which holds the unique values.
Another column named as "Description" which differentiates between different pnr.
Ex:-
PNR Description
123 AA
456. BB
789. AA
147. AA
250. CC
369. BB
So my question is how can I get the output in different sheet/different excel file based upon description.
Expected Output:-
Sheet 1:-
PNR. Description
123. AA
789. AA
147. AA
Sheet 2:-
PNR Description
456. BB
379. BB
Sheet 3:-
PNR Description
250 CC
Kindly advise.
Hope everyone is well & Safe !!
My requirement is like:- I have an excel sheet with a column name "PNR" which holds the unique values.
Another column named as "Description" which differentiates between different pnr.
Ex:-
PNR Description
123 AA
456. BB
789. AA
147. AA
250. CC
369. BB
So my question is how can I get the output in different sheet/different excel file based upon description.
Expected Output:-
Sheet 1:-
PNR. Description
123. AA
789. AA
147. AA
Sheet 2:-
PNR Description
456. BB
379. BB
Sheet 3:-
PNR Description
250 CC
Kindly advise.